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.
 
Back
Top