problems opening database when a report is opened in design view

[Pitoon]

how can i fix this problem, two computers on a network,
trying to acces the same database on a server. computer
one already has the database open in report design view.
computer two is trying to acces the database to get
information off the database. computer two cannot log on
because computer one has locked it somehow? is there
anyway to unlock this so computer two can have access at
the same time?

any info would be great

pitoon

 

[Cheryl Fischer]

No. In Access 2000 and newer, the database must be in Exclusive open mode
to modify the report.

The work-around, and a considered "best practice" is to deploy a Front-End
database (containing all Queries, Forms, Reports, Modules and Macros) to
each user's local hard drive. This database is linked to a Back-End
containing shared tables which is located on the server. You will also
maintain a copy of the FE on your computer, where you will do your
modification and testing. Once testing is complete, the new FE is
distributed to each user. There are a number of possible ways to distribute
modifications and updates to databases, one of them can be found at:

http://www.granite.ab.ca/access/autofe.htm