Laurie said:
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.