Shared Usage Issues

[Anthony the Frozen Michigander]

I inherited an old access database that has to be used by two users at the
same time. We find several problems: User 2 cannot sign in before User 1
otherwise we recieve the "cannot open file as is currently in use" message.
Sometimes having signed both users into the database we find that User 2
will be ejected from Access when she tries to open a query or autoform.
Sometimes User 1's Access will lock up until User 2 signs out of the database.

User 1 has Office 2007, User 2 has Office 2003 and the file is stored on a
Windows 2000 server.

Help would be greatly appreciated.
Thank you

 

[Larry Daugherty]

If your "users" are opening queries and Autoform's then they aren't
users, they're the *other developers*. Users should be using nothing
but the Forms provided for them by the developer. That includes
running any necessary Queries. No user should be allowed into the
Design functionality (Autoforms, etc.)

Each user should be using the MDE (not MDB) on their own desktop.
Given their differing versions of Access, that means a separate MDE
created for each of them in their native version of Access. Better
would be that their versions of Access be made the same and that the
*developer* create and distribute the MDE in the correct version of
Access. Once converted and distributed as an MDE, your development
burden will increase to provide any missing functionality that
required users to run queries directly or to create forms.

Only the BackEnd should be on the Server.

HTH