Split DataBase: Multi-User Disabled

[Dominick]

Hello Everyone,

I have a database which was splitted into two, One
holds the tables and the other holds the objects (e.g.
Forms, Modules, etc.) The problem that I'm having is that
I'm unable to use the multi-user option. It gives me a
message saying that the database which holds the tables is
already in use and cannot use it until the other user
exits out. I tried setting the database option of open
exclusive to no but no luck. Does anyone knows how to make
a splitted database multi-user?

 

[tina]

hi dominick, fellow citizen of riverside county, calif -
small world!

so the Default Open Mode, under Tools, Options, Advanced
tab, is Shared, correct? (fyi, i'm referencing Access
2000) is your "front end" database also defaulted to
Shared? and does each user access the "back end" database
from a copy of the frontend that sits on their own pc's
hard drive (in other words, NOT a shared frontend db
sitting on the server)? and have you checked with each
user to make sure nobody is selecting Open Exclusive, when
they open the frontend db?

if you answered yes to everything, my next thought is that
maybe your db is corrupted (either the frontend or the
backend). when's the last time you did a compact and
repair? you might find some helpful info at

http://www.granite.ab.ca/accsmstr.htm
tony toews is one of the Access MVPs that volunteer in
this newsgroup.

hth

 

[Dominick]

Hello,

It is a small world. I will check your sugestion. Thnx