Problem with Sharing Access database (2000)

Topic

New Reply

I am trying to share an Access database, so 2 users can access the database at the same time.
I am getting attached error message, is there any way to resolve this issue?

Reply | Quote

Replies

JJ,

First question is, have you split the front end from the data tables? This is recommended practice for several reasons. That way, each user can have their own copy of the front end.

If you have not gone down this route, then most probably one person has opened the database ‘exclusively’. The default mode is normally ‘shared’, but this can be changed. Or, they are in the process of making changes to database objects and this has locked the system.

Regards,

Reply | Quote

I now appear to get the attached error? , how can l by pass this error?
Can you tell me how l split the front end from the data tables?

Reply | Quote

(Edited by HansV to make URLs clickable – see Help 19)

You’ll see this, or a similar error, until all but one person has closed the database.
To split the front and back ends, the simple way is to take a copy of your file so there are two identical databases. Delete everything but the tables from one copy. Put this on a shared network drive. From the other copy, delete the tables. Then create a link to the back end tables on the network drive. Give a separate copy of the front end to each user. Do not move the back end, or the links will break.

There’s an old article about this at http://support.microsoft.com/kb/142467%5B/url%5D. A more up to date article is at http://support.microsoft.com/kb/304932%5B/url%5D.

Reply | Quote