Can't save report if other user in db

  • Thread starter Thread starter dw
  • Start date Start date
D

dw

Hello, all. We are developing an Access report, but if another team member
has the database open (not doing anything in there -- just having it open),
the person working on the report gets an error: "You do not have exclusive
access to the database at this time. If you proceed to make changes, you may
not be able to save them later." What would happen if the report developer
saves the changes while the other person is only viewing the database? Can
changes be saved while another user has the database open? Thank you.
 
That is why you split databases. Each user should have and use their own
copy of the front-end. Only the tables should live in a shared back-end
linked to the front-ends.

Rick B

Hello, all. We are developing an Access report, but if another team member
has the database open (not doing anything in there -- just having it open),
the person working on the report gets an error: "You do not have exclusive
access to the database at this time. If you proceed to make changes, you may
not be able to save them later." What would happen if the report developer
saves the changes while the other person is only viewing the database? Can
changes be saved while another user has the database open? Thank you.
 

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

Back
Top