By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,548 Members | 1,735 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,548 IT Pros & Developers. It's quick & easy.

Access 2003 - Exclusive Access

GrandMaster
P: 8
Hi all
When I used Access 97, I could edit reports and forms whilst other users had it open, the only problem was that the users had to close and reopen a form or report to see the form/report in it's new, edited state.

With Access 2003 I cannot do that as if anyone has got the database open I get this message
You do not have exclusive access to the database. Your design changes cannot be saved at this time.
.

Is there anyway to avoid this?
Apr 2 '07 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi all
When I used Access 97, I could edit reports and forms whilst other users had it open, the only problem was that the users had to close and reopen a form or report to see the form/report in it's new, edited state.

With Access 2003 I cannot do that as if anyone has got the database open I get this message .

Is there anyway to avoid this?
This is a safety measure that has been introduced to reduce corruption of databases. Always work on a separate copy of the database to the live version.

Mary
Apr 2 '07 #2

GrandMaster
P: 8
Thanks Mary

I understand that was the reason for it's introduction, however in regards to Reports based on Queries, it was never a problem as the other users were only using the forms feature and would never edit either the query or the report.

Is there any way around it as it's not very practicle to copy the database every time I want to make a minor change? I have 10 other people all using the database form and they all have to close while I replace the old database with the new copy just to make a change to one report.
Apr 2 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks Mary

I understand that was the reason for it's introduction, however in regards to Reports based on Queries, it was never a problem as the other users were only using the forms feature and would never edit either the query or the report.

Is there any way around it as it's not very practicle to copy the database every time I want to make a minor change? I have 10 other people all using the database form and they all have to close while I replace the old database with the new copy just to make a change to one report.
I'm not aware of any way around it.

Mary
Apr 2 '07 #4

GrandMaster
P: 8
Oh well, thanks anyway.

I should have stayed with Access 97, the upgrade has just made my job more difficult.

If anyone knows of a way around this I would really appreciate it.
Apr 2 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.