Might be the wrong Group, but why can I not open my forms

  • Thread starter Thread starter Fred Wilson
  • Start date Start date
F

Fred Wilson

Hello,

First I would like to thank you all for your help so far.

The application I have made is working pretty good, HOWEVER, if anyone
has the FE application open no one else can open it, except me on my
normal workstations. It gives me some kind of warning that I do not have
exclusive rights so I can not work on it. What I was doing was making
more reports while the users are inputing the data.

Because this is a brand new thing for our office, one person puts in the
data, another on another machine should be verifying the input, and
finally, myself doing the complex data evaluation and programming more
capabilities.

I never had this problem in Acc 97 but this is Acc XP/2000.

Thank you,
Fred
 
From Access 2000 and later there is a monolithic save model. You cannot save
any design work while anyone has the database open. The work-around for
objects is to split the database (which is imperative in a networked
environment anyway) and put a copy of the front-end on each workstation,
linked to data tables on the server. You can work on your copy without any
problems, then put a copy on the server. Everyone can then download the copy
from the server.

You can automate the download process with a Starter file such as:

http://www.datastrat.com/Download/Starter.zip

or check Tony Toews website for AutoUpdaterFE

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Well this explains that problem, but why can I Open the back end when
someone else is in the DBS but others can not. It says something about
being in exclusive mode.
 
Back
Top