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?

[MMcCarthy]

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

[GrandMaster]

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.

[MMcCarthy]

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

[GrandMaster]

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.