I'm wondering if adding an autonumber primary key will improve the
performance of a multiuser access database on a network share.  I have
a website that lists many tips for improving performance of access, but
doesn't mention primary keys.

I have an MS access database that gets used at multiple machines over a
network. There are a number of useful autocomplete entries I have
entered manually into individual installs of MS access. Is there a way
to have autocomplete entries travel with the MS access database (so all

Was just wondering which is faster, a subreport or dlookup.
I've got a report with either 5 subreports or lots of dlookups.  The
subreports generally have anywhere from 5 to 12 controls on them so if I
don't do the subreport thing, I'm doing TONS of dlookups.

Seems like there are three ways to post a request to a web service:
------------------
- SOAP message
- HTTP Get

How will Access fair in a year? Two years? .... The new version of
Access seems to service non programmers as a wizard interface to
quickly create databases via a fancy wizard.  Furthermore, why would
you even continue to use Access as a backend when you have a much

I am kind of new at Access (pretty good with VBA I think :). I am
trying to retrieve data using SQL statement. I have a table with 5
field: ID (Access given), Card1, Card2, Group, Point.
I want to see other values based on Card1 and Card2. I think I can get

I am using the following code to run a query:
DoCmd.OpenQuery "qryLocation", acNormal, acEdit
The query works fine, but the results of the query display on the screen.
This was helpful when I was designing/debugging the application, but it is

Could someone please explain and help me fix the following error?
"ADO error: MSDTC on server 'myServer' is unavailable"
It came up when I tried to run a query.
Thank you!!

I want to reference code in an external Access Database, and refresh
that database (by downloading from network location). Do I need to
bootstrap? Or is it possible (during autorun) overwriting the
referenced database?

I have been trying to make a web site for my wife to display contents of a
soon to be built database.  I tried with phpmyAdmin and MySQL.  it seemed
like too much for me to learn at once. So I am going to try this with Access
and see what happens.  My goals are to eventually be ...

I want to add a Label or a Text box to a form and change it's text when one
of several Command buttons is clicked.
The MsgBox isn't suitable because it pops up a box that the user must close
befor continuing.

I have a problem that I'm a little stumped by and need some help if
possible.  I need to generate a report in Access 97 from 2 tables (easy
so far) but it requires a calculated date based on several factors
including whether a date is present in one of three fields.

I am trying to make a finances database.  I have a master table which
contains transaction header info and then a line details table.  What i
want is to make a reconcile query where i can see simply the date,
account and posted (boolean field) from the transaction table and then

I my form I have put record navigation buttons. When I choose just
before the last record, the "Go to next record" button, access
automatically start with a new record instead of a message that theere
are no records after.

I needed to import large CSV files into Access, when requested by a
command in a .Net interface.
Because Access does not have a bulk insert command, and I already have
vba macros in Access that do the import, I simply called the vba macro