Exclusive access to the database for report writing

K

Kenny B.

We have a multi-user environment for our church membership database. When I
attempt to write a report, I get a warning saying I must have exclusive
access to the database. This means that I have to ask everyone else to get
off the system, or else stay late when no one is here. Is there a way I can
write reports even when others are logged on?
 
T

tw

I think you are asking how can you create reports? You should be able to
run a report without exclusive access. You have a couple of options... Make
a copy of the database and create you report in the copy. When everyone is
out of the database (only takes a couple of seconds) you export your report
from the copy to the original. Then the users can get back in. Or you can
split the database and give each of the users a front end with reports,
queries etc and have the back end with only tables. You make create your
new reports in the front end and when finishd you can update the users with
an auto update program or manually.
 
T

tw

If you read these newsgroups often, you will find that splitting is the best
option. However, always make your changes to a copy of the original
database. Do not make changes to the only copy of the database you have.
 
V

Van T. Dinh

You probably have "All Records" in the "Record Locks" Property of the
Report.

Try changing this setting to "No Locks".
 
Top