Error Message received

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

In Access I get the following message:

"You do not have exlusive access to the database at this
time. If you proceed to make changes, you may not be able
to save them later."

Any ideas?

Michelle
 
If you are using A2K or later, this is the normal behaviour: you get this
message when you open an Access Object in DesignView.

Unlike A97 or ealier version, you can only save the Design of an Access
object if you open your database exclusively.
 
Michelle said:
In Access I get the following message:

"You do not have exlusive access to the database at this
time. If you proceed to make changes, you may not be able
to save them later."
Click to expand...

What are you trying to do when this happens? Are you trying to update
the queries, forms, reports, macros or modules in the MDB?

If so 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.. It also supports
Terminal Server/Citrix quite nicely.

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
 
Back
Top