can't work on database if someone is in DesignMode

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)
 
K

Kevin3NF

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top