prob: don't have exclusive access to databases....

[Ron]

I have converted an Acc97 to Acc2k, and have made changes
in the objects--forms, report, queries, etc . After
making some successful changes in the objects, Access
started to give me an error message of "You don't have
exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them
later". I have looked on the MS knowledge base for a
solution and nothing helpful is suggested. MS does
acknowledge that this is a problem....any solutions out
there...
Thanks very much...would appreciate help...
Ron

 

[Allen Browne]

If this database is in use by others at the same time, split the database
(Tools | Database Utilities | Database Splitter) and give the others their
own front end.

If it's not, try to trace what else you have that's using the object. For
example, if you have a form open, you cannot change the structure of the
table that is supplying the records to the form. Sometimes it's a matter of
failing to close your objects (e.g. recordsets) properly in your code, and
set all objects to Nothing.

 

[Tony Toews]

I have converted an Acc97 to Acc2k, and have made changes
in the objects--forms, report, queries, etc . After
making some successful changes in the objects, Access
started to give me an error message of "You don't have
exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them
later".

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 my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless..

Tony
--
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

 

[dayle]

I knew I had a fix hidden away somewhere in my "code"
drawer!!! I created the following code in a module and
then call the function in a RunCode in autoexec macro.
This code then fires everytime the database is opened.
Note, I have two other things I like to have as default,
that is to set the record locking as that isn't set by the
owner of the database but by the user's perference and key
behavior I changed.

Public Function ChangeRecordLocks()
Application.SetOption "Default Record Locking",
2 'edited records
Application.SetOption "default open mode for
databases", 0 'sets database to shared
Application.SetOption "behavior entering field",
2 'sets cursor behavior to End of text when text field
gets focus