469,326 Members | 1,478 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Access 2003 - Exclusive Access

GrandMaster
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
4 1525
MMcCarthy
14,534 Expert Mod 8TB
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
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
14,534 Expert Mod 8TB
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
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.

Similar topics

18 posts views Thread by Andre Laplume via AccessMonster.com | last post: by
6 posts views Thread by Jan Janssen | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.