Shared Usage Issues

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony the Frozen Michigander - 22 Jan 2008 23:57 GMT

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

Reply to this Message

Larry Daugherty - 23 Jan 2008 06:14 GMT

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

Signature

-Larry-
--

> 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
[quoted text clipped - 8 lines]
> Help would be greatly appreciated.
> Thank you

Reply to this Message