MsysAccessObject opening as exclusive

  • Thread starter Thread starter Laura Breitenbach
  • Start date Start date
L

Laura Breitenbach

Good morning!
I am requesting help on something that has myself, another
support group and our IS department scratching our heads.
First a little background: We use mainly Office XP, but
still have some 97's. We also mainly use Windows 2000,
but still have a few 98s and NTs and our network is
Novell. The database was originally created in 97 then
brought up to XP. I have also tried creating a new
database and importing all the tables, queries, forms,
code, and macros. I have also tried compacting and
repairing and have looked at the network clearance. All
the users Access setting are identical and every ones
default opening mode is "Shared" and NOT "Exclusive".

Now for the issue:
In the past month, we have started getting the following
errors, "The table 'MsysAccessStorage' is already opened
exclusively by another user, or is already opened through
the user interface and cannot be manipulated
programmatically." We also get this same error sometimes
for 'MsysAccessObjects'. And other times it will just
tell us, "Microsoft Access can't find the database
file 'o:\dept\rfq\quote_team\rfq.mdb.' Make sure you
entered the correct path and file name."
We get these errors anytime some one tries to access the
database while someone else is already in it. I have even
tried to split the database and still get errors that the
database is already in use by another user.

We didn't use to have this problem and were able to have
multiple people in the database at the same time. We all
have the following rights to the directory: Read, Write,
Create, Modify, Erase, & File Scan.

Can anyone help?

Thank you in advanced,
Laura Breitenbach
 
go to microsoft knowledge database and look up article
number 818099. This will tell you about the
MSysAccessObjects error and curing this may solve your
other problems.
 
Thank you for your reply. I did pull up this article, but
it was for a 'TempMsysAccessObjects'. I tried it any way
(I'm game for any thing that might help or work), but
still get the same error for 'MsysAccessObject'
& 'MsysAccessStorage'.
Any other ideas?
 
Laura Breitenbach said:
In the past month, we have started getting the following
errors,
Click to expand...

Was it a month ago when you converted the MDBs from A97 to A2002/AXP?
"The table 'MsysAccessStorage' is already opened
exclusively by another user, or is already opened through
the user interface and cannot be manipulated
programmatically." We also get this same error sometimes
for 'MsysAccessObjects'.
Click to expand...

Unusual messages. There are very few hits on MsysAccessStorage and
MsysAccessObjects.
And other times it will just
tell us, "Microsoft Access can't find the database
file 'o:\dept\rfq\quote_team\rfq.mdb.' Make sure you
entered the correct path and file name."
Click to expand...

Hmmm, going to ignore this one for now.
We get these errors anytime some one tries to access the
database while someone else is already in it. I have even
tried to split the database
Click to expand...

A2000 and newer are much less forgiving on sharing an MDB than A97
was. You really need to split the MDBs.
and still get errors that the
database is already in use by another user.
Click to expand...

Import the MDB into a new MDB and see if that clears up that problem.

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