Write Conflict settings

T

Ted Stilwell

We recently upgraded from 97 to 2003. In 97 I could change the design of an
object in a db as long as no one else was using that specific form, query,
table, etc.

Since the upgrade I cannot do these things unless I have exclusive access to
the db. Is this normal for 2003 or is this a selectable that the network
administrator could have unselected during installation.

Many thanks in advance for your help.
 
R

Rick Brandt

Ted Stilwell said:
We recently upgraded from 97 to 2003. In 97 I could change the design of an
object in a db as long as no one else was using that specific form, query,
table, etc.

Since the upgrade I cannot do these things unless I have exclusive access to
the db. Is this normal for 2003 or is this a selectable that the network
administrator could have unselected during installation.

Many thanks in advance for your help.
Click to expand...

97 was the last version to allow that.
 
D

Douglas J. Steele

As Rick states, because of changes to Access, all versions since Access 2000
have required you to have exclusive access in order to save design changes.

However, this shouldn't be an issue: all applications should be split into a
front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing the tables and relationships). Only the
back-end should be on the server: each user should have his/her own copy of
the front-end, preferably on his/her hard drive. With that set-up, you'll
always have exclusive access to the front-end. (In actual fact, that's how
your Access 97 databases should have been set up as well.)
 
Top