Is there a way to add a field to an existing table using a query of
some sort (without needing to manually add a field to the table).  I
know how to do it with a make table query, but I have a specific need
to only add a new field to a table if possible.  Here's a simplified

I have a small Access 97 application and I want to deploy these
application on other computers (with XP Pro). Which DLL and Exe must be
present to run my MS Access application ?
thanks,

If I create a database in Access 97 on a Windows platform, can I use it on
an IMac as well?
Thanks

Was wondering if anyone knew of any references for solving particular
database problems with Access.
For example, how to create databases with transaction tables (I know
they're not built in to Access, so I want to know how to construct

Our users run a Microsoft Access application, on a Terminal Server.
When users connect to the Terminal Server for the first time, MS
Office XP requires them to enter their User Name & Initials. Is there
a way to eliminate this requirement or use a default (which could be

I'm a novice Access user and am not sure how to solve the following problem.
Any help with the following would be greatly appreciated!
I have two tables with identical structures, the first holds the data input
for a questionnaire, the second holds the scores from the questionnaire, ...

How can I retrieve just the column names from an Access table. I don't
need the data, just the column names.

I'm using access 97 SR2 on win XP and keep getting the Sub or Function
not defined error message.
The code for the function is in a module called mod_Public and is as
follows.

I have a form where the user types the shipping container number into
a box and then types the Pallet number into a combo box.  The
AfterUpdate event for the combo box runs the following code which
finds every table row that has that pallet number in it and sets the

I'm very interested to hear if anyone has created an access database
that enables a user to cut and paste an image from a web page into a
database.
The database then stores the image and then allows the user to cut and

is it somehow possible to export the DESIGN (not the data) of a form
into a textfile or something like this? and of course a have to
reimport this later.
i need to change multiple elements (exspecially the elementnames) in

I am using code provided by Mr. Steele that allows for my MDB to
dynamically connect to remote SQL server databases.  The code works
fine as follows:
Type TableDetails

I have an unbound listbox in my main form that is used for reference only.
If I want to add a record to the table that this list box displays, I open a
seperate form to enter a new record to the table.
What I would like, is for the list box in the main form to refresh after the

The following code correctly creates the string and if I paste this into a
query it works everytime. It doesnt work though with the query Exists
function in as much that if the query is already there the set querydefs
part of the code doesnt update the sql so I get the string from ...

What's better/ faster/ more efficient. Using Docmd.RunSql or Execute
to run sql? When is one better than the other or inappropriate to use?
Thanks.
jim