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?