how can I save a report if I am on a shared network

[Guest]

I am in a small office, and our PC's are networked through a server. Our
Access database resides on the server. We recently upgraded from Office 1997
to Office 2003. When I create a new report in Access 2003, it says I cannot
save it because I don't have exclusive access to the database. Office 97
would give me this message if I were trying to change a form or table, but it
would let me save new reports. Is there a way to save a new report in Access
2003 if others are using the database? It is frustrating to create a report
and not be able to save it. Thanks for any help.

 

[Allen Browne]

Yes, this is one of the frustrations in updating. In Access 2000 and later,
Microsoft introduced a monolithic save.

If you have multiple users in the same database at the same time, you
*really* need to split it into two files:
- one that contains all the tables, and resides in a shared location on the
server;
- one that contains all the other objects (queries, forms, reports, ...),
with linked tables.
Each workstation has its own local copy of the front end.
More info in:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

For other issues you need to be aware of, see:
Converting from Access 97
at:
http://allenbrowne.com/ser-48.html