Tony,
Can you tell me what registry setting is used to determine version of
MS Access used when StartMethod=AutoSelect is used?
Here's my situation. I've installed Access 2007 to test it, but use

I'm writing a SELECT SQL statement and need to use an IF THEN statement in
the select line.  I have one field that selects Point Deductions and I want
to create another field that says "IF Point Deduction is > 26, then PRINT
"Fail" ELSE PRINT "PASS".  I know its possible to have ...

I have a database used by multiple users that today is stating that
the database is read-only when it is opened.  This database has tables
that are updated each night and suddenly developed this error today.
The file attributes are not set to "read only" and neither is the

I'm not much of a wiz but am hoping that someone can point me in the right
direction.
Our business has a small office workgroup of Laptops & one office machine.  
We all share an MS Access 2000 database, which is stored on the office

I manage a FE/BE database and have 12 users.  I have the FE on their local
drive and the BE on the network.  Works great for all but one.  When I try to
open the database from one particular user's station, I get the following
error (I have substituted "File Path Name" for the ...

Has anyone a good idea how to solve the next issue:
There are two forms: Clients and Volunteers, both have a subform one for
the help needed the other for the help offered. The values in the field
are looked up in a table and the value is a number. So in the list

I made this dbase with frontend and backend, plain .mdb files. The
backend is on a shared folder (MS server 2003)  Now when i look in de
data after a while there are duplicates all over. For a time i did not
set the lock record on de forms. Is this the problem or are there other

Our company recently switched over to a Microsoft 2003 server and I
noticed in our database, before several employees could work in the
access database.  Now only 1 person at a time can enter the database.
I splited the database and a shortcut of the front end is on each

We have an Access application, FE on each user pc and the BE on a
networkdrive. At some moment in time the applications crashes. According to
the network specialist it is because there are too many file locks.
Any idea how to avoid this?

We have a split multi-user DB, BE on server, FE on each user's PC.  (Access
2003 running on Windows XP.)  and work correctly for each user.  However,
the process speed is too long as compared to working locally on each
computer.  Normally, it takes 2-3 second process on local ...

I have several backends on a remote desktop connection.  One of them has an
ldb file which I can't delete.  I've used Computer Management to close all
open connections to its mdb file, but I still can't delete the ldb, and can't
compact/repair the mdb.

I am using access2000 recently upgraded from access97 on a multiuser
environment where the access2000 application is on the server.
It happens sometimes to get the message "Database not recognised or needs
repair" . I have created a user like Admin with Admin rights and if ...

I have some code I wrote in an Access 97 database that gets the number of
users in a database using the msldbusr.dll.  I am using the same code in an
Access 2003 database.  The code isn't working in 2003 - it is returning an
incorrect number of users.  Does this dll not work with ...

Please may be anybody has any idea why access database (Windows 2000
format, it is used by 5-6 users using windows 2000, 2003 and XP) does
not work preperly as soon as it reaches size 40 MB? Sometimes we can
not open it, sometimes it hangs...