Update report

H

Hong

I want to make change to the report design, but the database is already
issued to the group, every time I open the report in design view, it tells
me: I don't have the exclusive access to the database at this time, I may
not be able to save them.

What should I do if I want to make the change to the database.
Thank you!!!
 
J

Jeff Boyce

Based on the message, I'm guessing that your database is but a single copy,
shared by all users. This design can result in higher risk of corruption,
and it makes it more difficult to do things like, say, update a report
design!

The preferred design is to use a single data store file/back-end (Access
..mdb or SQL Server or ...), and give each user a copy of a "front-end" (no
data; queries, forms, reports, ...).

This approach allows you to work on a copy of the front-end at your PC
without contention, as each of the other users is using his/her own copy.
When you've finished your updates, you will need to deploy copies of the
revised front-end to each/every user.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

The piece I left out was that you'd use File | Get External Data | Link...
to connect the tables in the back-end to the front-end before distributing
copies to the users.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
H

Hong

There is a master database only have tables. The database which using by
everyone have some tables link to that master database, and also have forms,
queries, reports.
So what I need to do is update the reports. Is this one still a single copy?
how can I get into it to update the report?
 
H

Hong

Thank you for you response.
The user are using the version 4.13. The adminstrator are using 4.14 (Not
issue to the user yet). should I update 4.14 or 4.13?
 
J

Jeff Boyce

I'm sorry, but I have no idea how version 4.13 or version 4.14 pertains to
my question about whether all users try to share a single .mdb file, or if
each user has a "front-end" file that links to "back-end" data.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top