Using Access 2000 and 2002 on a shared database locks out users

[Guest]

I have a multi user database with some on Access 2002 and some on Acceee
2000. If the first person to open the database uses Access 2002 it locks out
2000 users. If the first user opens in Access 2000, all users can get in.
Short of updating eveyone to Access 2002 how can I solve this?

 

[Rick Brandt]

I have a multi user database with some on Access 2002 and some on
Acceee 2000. If the first person to open the database uses Access
2002 it locks out 2000 users. If the first user opens in Access
2000, all users can get in. Short of updating eveyone to Access 2002
how can I solve this?

Do you have multiple 2000 users and multiple 2002 users and this scenario plays
out the same regardless of which 2002 users opens the file first? You might be
jumping to the conclusion that the Access version is the key variable when it is
more likely that it is the *user* who opens the file first that is the culprit.

All users must have permissions on the folder where the file resides to...

Create new files
Open existing files
Modify existing files
Delete files

If the first user to open the file does not have "Create File" permissions on
the folder then Access will not be able to create an LDB file (required for
multi-user access). This will mean that this first user will open the file in
exclusive mode locking everyone else out.

I don't know of anything like this that is related to the Access version being
used.