By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,122 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,122 IT Pros & Developers. It's quick & easy.

You do not have exclusive access to the database

P: n/a
Access 2000 onwards introduced a restriction that only allows you to
edit and save forms, reports and macros when you have exclusive access
to the database, i.e. no other user has the database open. Is there
any way to overcome this behaviour to allow these objects to be edited
while other users have the database open?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The best solution is to split the database into two:
- a single data file containing all tables, shared.
- a local copy of the program file on each workstation, linked to the data.

Now you can modify your own copy of the database to develop queries, forms,
reports, and code, and simply release an update to the users once your
testing is complete.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alan Jones" <al**@activ.co.uk> wrote in message
news:c2**************************@posting.google.c om...
Access 2000 onwards introduced a restriction that only allows you to
edit and save forms, reports and macros when you have exclusive access
to the database, i.e. no other user has the database open. Is there
any way to overcome this behaviour to allow these objects to be edited
while other users have the database open?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.