does xp lock the database when someone is in design mode?

S

sd

We just converted to xp from access 97 and it is locking the database if
someone is in design mode. Is this new or is there a way to get around this.
The database is shared and not open exclusively.
 
T

Tony Toews

Kevin3NF said:
Split the data base into FE/BE so if one person is in design mode on his FE,
he's not affecting the others.

Yes, this is new with 2000 I think.
Click to expand...

Correct, this is new in A2000.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Tony Toews

Tony Toews said:
Correct, this is new in A2000.
Click to expand...

I should clarify this though. In A97 when two developers were working
in an unsplit MDB we had a much greater chance of corruptions. So
yeah, I guess you could say we were affecting the other person.
<smile>

In A2000 though MS put a stop to this and gave you that error message.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
what does FE/BE 1
lock and unlock the design mode of access database 2
lock and unlock design mode of Access DB by password 1
Cannot go to Design View although only one in database 2
Exclusive mode 4
Linked Excel tables opened exclusively 4
Locking tables when in shared default open mode 2

Top