Save Changes on a Multi User Network

[laffspotpc]

First, thanks for any help. I have a network with multi users. In Access 97, I could change the design of a form while others had the database open. I have converted to Access 2000 and now when I go to design a form I get this message: "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.". The only way to avoid this is to have all the useres close the database. Is there away around this?

Thanks
Bill

 

[batteam]

No, there's no way.

What you have to do is have a 'Development' copy of the db in another folder. Make your changes on that copy then, when everyone is off the Production version, copy it over.

Besides, you don't want to make changes to a form or any object when somebody might be using it. But you can add, edit or delete records to tables without any problem - but of course, you can't make any column design or property changes.


Hope this helps.