can't work on database if someone is in DesignMode

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Hi,
I have a user that created a MS Access xp database.
It's got several tables... queries.. blah blah blah

It's residing on our novell networks main server.
And so... several employees are able to get into the
database whenever.

The other day... the design person making this database
was in design mode... workign on a query or something.

And a regular user was also into the database... over the
network... this person was not allowed to enter anything
into the database.. cause it was saying that they didn't
have exclusive rights.. or table was in use or something..

How can i fix this...
so that the employees can work in the database... even if
the creator of the database is also in it.. and designing
queries or reports or whatever

thanks
any help is greatly appreciated.

-Aaron
(e-mail address removed)
 
Split the database into a Front-end/Back-end setup, each user (including
your deloper) having a copy of the FE on their local hdd. When the
developer has changes that are ready, end the new FE out to the users.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top