HELP:::You do not have exclusive access to the database at this time

[Jose Manuel]

Hi guys,

I have a simple application, that was developed using Access 2000. It has
several forms, the problem is that when an user tries to update a record and
another has a form open, the following error shows up "You do not have
exclusive access to the database at this time".

Anybody knows how to fix it??

Thanks.

 

[Guest]

Sounds like you have set up the database as one file that all users are
trying to access at once, which is fraught with danger.
You really need to split your database into a front end and a backend, put
your backend on a server somewhere, and give all your users their own front
end.

There's little point on writing too much about it here, do a Google search
for keywords such as front end, backend, Access, Database, Split, and you
should get plenty of info. Better still, check out the Access sites listed on
www.mvps.org, everything youy need to know is there.

HTH

Neil
www.nwarwick.co.uk