Exclusive access

  • Thread starter Thread starter BarbaraH
  • Start date Start date
B

BarbaraH

I started writing a database in Access 97 and then
upgraded it to Access 2002 when our organization upgraded
to XP/2002.
I'm now in a situation where I can't make design changes
to the database if any other user has the database open,
even if they are not accessing the form or query or report
that I want to change.
I get a message saying that I don't have exclusive access
to the database and that any changes I make might not be
able to be saved. And sure enough they won't save.
Any explanation/workaround would be appreciated.
At this point I don't have any user level security
implemented, but ultimately plan to create read-only user
ids, data editors and me as administrator.
 
BarbaraH said:
I started writing a database in Access 97 and then
upgraded it to Access 2002 when our organization upgraded
to XP/2002.
I'm now in a situation where I can't make design changes
to the database if any other user has the database open,
even if they are not accessing the form or query or report
that I want to change.
Click to expand...

That's one of the things that changed starting with version 2000.
Any explanation/workaround would be appreciated.
Click to expand...

You should split your database into frontend (all the objects except the
tables) and backend (just the tables/relationships). Put the backend on
your server, and give each user a copy of the frontend (which will be linked
to the backend). You can make all the design changes you like in your copy.
Once you have completed testing, you can copy the revised frontend to your
users.

Check out Tony Toews' site for AutoFEUpdater, which you can use to automate
the distribution of frontend changes.
http://www.granite.ab.ca/accsmstr.htm
At this point I don't have any user level security
implemented, but ultimately plan to create read-only user
ids, data editors and me as administrator.
Click to expand...
Be sure to study the security FAQ at

http://support.microsoft.com/?id=207793

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
 
Thanks for clarifying that this changed with v2000.
I will split the database.
Regards,
bh
 
Back
Top