Multiple User Problem in Development

[mikemaki]

Currently we're in migration from ACCESS 97 to 2000. We're having a lot of fun(not) with all the new idiosyncracies we have to learn. One of them has to do with multiple users in development. 97 allows two users to make changes to objects in a database at the same time. When one developer saves they are asked if they would like to overlay changes made by another user. By choosing No they can save their changes without disrupting the other's changes. 2000 isn't acting like this for us. One user locks out the other. Is there any setting we can use to allow multiple users to make change to a database?

 

[WayneRyan]

Mike,

For a quick fix, Access 97 sure made it easy to go in a change
a line of code or something.

In A2000, we develop/research/test outside of the production
system. When we have changes, we come in at "programmer
times" (read: outside of normal hours) to post the changes
by importing forms, etc.

Wayne

 

[rpadams]

Can be done, but not easy

Ac2K has many more restrictions on multiuser changes to the database. The link below tells you all about it. When you get done reading it, you'll probably agree that WayneRyan's method may be the better way (or ONLY way!) to go.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;200290