You do not have exclusive access to the database.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anoyse - 27 Jul 2005 16:31 GMT

Hi,

I have a database residing on a shared network drive and I have 16 users
accessing it using a desktop shortcut.

They are able to open the database and enter data however when they go to
save it to the table they get the "You don't have exclusive access to the
database" message. Here's the funny part after they click OK to get rid of
the message the record is saved to the table anyway.

Is there a way to stop this misleading message from appearing? I've tried to
unclick everything in the 'TOOLS. OPTIONS, EDIT/FIND' tab. Is there somewhere
else I can turn off the warning?

Thanks in advance for any advice.

Reply to this Message

Tony Toews - 28 Jul 2005 03:13 GMT

>I have a database residing on a shared network drive and I have 16 users
>accessing it using a desktop shortcut.
[quoted text clipped - 3 lines]
>database" message. Here's the funny part after they click OK to get rid of
>the message the record is saved to the table anyway.

Chances are you are using some code to save the record which looks
like

DoCmd.RunCommand acCmdSave

However the above is misleading. It want's to save the object, in
this case the form.

You really want the below syntax.

DoCmd.RunCommand acCmdSaveRecord

However this message illustrates a fundamental flaw in how you are
doing things.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Reply to this Message