Access 2003 Exclusive Access

  • Thread starter Thread starter katz
  • Start date Start date
K

katz

Hello!
I have Admins access to my database, but if any body is using the database
and I want to open in design view a form or report to change, I get this
message "You do not have exclusive access to the database at this time".
I didn't have this problem with Access 97.
Thanks for your help.
Abe
 
All versions after Access 97 require that the file be opened exclusively to
make design changes.
 
As George points out, you've needed exclusive access to make design changes
since Access 2000.

However, that 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 a copy of the
front-end on his/her hard drive. In that way, you can make changes to your
heart's content, redistributing the new front-end when you're satisfied.

To automate the redistribution process, take a look at the free Auto FE
Update Tony Toews has at http://www.granite.ab.ca/access/autofe.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

Can't create a report from my query in Access 1
Opening Database 1
Saving design changes to upgraded databases 4
Unable to create forms in database 1
Access Exclusive Use problem in MS Access 1
Exclusive access to db 2
Exclusivity errors when entering data after upgrade 3
Forms use linked tables and have multiple users 3

Back
Top