Does anybody know how could I manage to do a sentence like this...
ALTER TABLE Table1 DROP COLUMN Col1
after doing a DML sentence like and UPDATE, INSERT or DELETE.
I'm using ADO commands to execute all thiis sentene from VB.

I have people in the field submiting excell spreadsheets
through a website which is tied into a SQL server which I
am linking to in my database in an OLE field. But when
they come into the DB it is as long binary data, which I

I want to set up Access to use a barcode scan for admission to the
lunchroom at the school I work at. We already have the scanners and
computers. I just need to set up a program to recognize the student
barcodes on their ID cards to know which students can be admitted and

Another Q,
Because we sometimes need to repair the shared database I would like
to find out if there is a way to "kick" all users from a database. The
problem is that I cannot repair the database when it is beeing

I have a two column table containing numbers.  I would like to make a
third column called fieldname "special".  In this column I would like to
put the following:
if column A = column B, then nothing in column C

I wonder if anyone has some ideas on the best way to create this type of
query.  I have a table of four columns.  The first column field is
called "year" and contains years from 1980 to 2003.  I have a standard
set of years which I have to convert all of the year values in the table

OK this is really bugging me.  At one time, Access always listed objects
in the main window in alpha/collating sequence.  Now it seems it
displays them in most recently used sequence.  Is there some way or
parameter (that obviously I have missed) to set it back to always list

I've been asked to look around, offshore, for somebody to do some access
work, and I'm supposed to do the QC. I guess I'm fine with the concept, but
has anybody done this and how did it go? Can you recommend any resources?
What is the deal with "international" versions of ...

How do I set up a report that runs after the user selects a month,
(from a combo or list box on a form) so that the only data in the
report is data from the month selected?  I'm not too good with VBA
code, but I can copy/paste and edit to my needs fairly well.

I am creating a contact database and I would like my user to enter
postal code (Canadian) and the city/province will be automatically
filled in. I am sure this can be done and I can probably buy the
databse/software, but I was wondering if I can get a free

We have XML files (and its XSD) that are dump of our tree-like data
structure in memory. These XML files may potentially have unlimited
levels of nesting because some elements can contain themselves
(recursively defined).

I am using a SQL Server 7 databaes with an Access 2000 front-end.
I have a form where after the user inserts a record the screen
refreshes to display a completely different record (without any prompt
to do so in the code).

I have an OLE Object type field in an Access database.  The objects in
this field are files which are linked rather than embedded.
My question is, how can I get a given object's location as a string?
I have tried the following:

I was wondering if it would be possible to snapshot an access report
to Outlook, and have fields come in the To: and Cc: fields, and also
the subject field of the email as well.  Right now, I am able to click
on a button on an access form, and have it snapshot the report to an

I'm not talking "Days of our Lives", only church stuff.  What's the
most efficient way to show relations among members, have a member
table, then a relations table (member 1, member 2, relation)?  Or is
there a better way?