Multiple Users in Datbase

[Laurie]

Our organization uses access for tracking projects. We are attempting to upgrade this database from Office 97 to XP. The only problem is XP will not allow us to have more than one user logged in to the database at once. We need to have the ability to have multiple users using the database at once. Any suggestions would be appreciated.

 

[Joan Wild]

You should not be having problems using Access 2002 (XP) in multi-user
environment.

Ensure that all users have full windows permissions on the folder where the
mdb is.

If this is not the issue, please post back with the specific error message
you receive when the second user opens the database.

--
Joan Wild
Microsoft Access MVP

Our organization uses access for tracking projects. We are attempting to

upgrade this database from Office 97 to XP. The only problem is XP will not
allow us to have more than one user logged in to the database at once. We
need to have the ability to have multiple users using the database at once.
Any suggestions would be appreciated.

 

[Bruce M. Thompson]

Our organization uses access for tracking projects. We are attempting to

upgrade this database from Office 97 to XP. The only problem is XP will not
allow us to have more than one user logged in to the database at once. We need
to have the ability to have multiple users using the database at once. Any
suggestions would be appreciated.

I am guessing that your database file is located in a shared location and
accessed by multiple users? If this is the case, you should see the following
page at Tony Toews' web site that you should find helpful:

Splitting your Microsoft Access MDB into a front end and back end
http://www.granite.ab.ca/access/splitapp.htm

If this is not the case, you might need to check the permissions to the shared
directory in which the database file is situated. All users should have full
permissions, including read/write/create/delete. Without create permissions, an
LDB file cannot be created and, after the first user opens the file, other users
will get a message that the file has been opened exclusively and they will not
be let in.