MS Access in multi-user mode..

[Guest]

I can't get MS Access into multi-user mode even though I have the DB set to
multi-user under Tools/Advanced. Please help. Thanks.

 

[Arvin Meyer]

I can't get MS Access into multi-user mode even though I have the DB set to
multi-user under Tools/Advanced. Please help. Thanks.

Do you have the database split so that all the data tables reside on a
server, and are linked to the front-end on each persons workstation?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

I can't get MS Access into multi-user mode even though I have the DB
set to multi-user under Tools/Advanced. Please help. Thanks.

It only takes one person logged on exclusively to lock everyone else
out. Occasionally the LDB file (Locking DataBase) may be hung up. In that
case get everyone out of Access and then delete the YOURDATABASENAME.ldb
file. Make sure everyone has delete rights to the directory where the
database is housed. Make sure you have a copy of the database since some
day someone is going to delete it.

 

[Guest]

Oh, boy... I thought I was so clever!

"...database split so that all the data tables reside on a
server [they all reside on the same server, but I'm not sure what you mean
by 'split'], and are linked to the front-end on each persons workstation [got
me, again; what does 'linked to the front-end on each persons workstation'
mean?

Thank you very much for taking the time to help.

 

[Arvin Meyer]

If you're not sure, let the wizard do it for you. First make a copy of your
database (make 2 or 3 copies if your unsure of yourself) Then Open a
database, using the menu, go to: Tools ... Database Utilities ... Database
Splitter and just follow the wizard. Put the front-end on a desktop. If the
links break, just use the relink wizard: Tools ... Datbase Utilities ...
Linked Table Manager
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Oh, boy... I thought I was so clever!

"...database split so that all the data tables reside on a
server [they all reside on the same server, but I'm not sure what you mean
by 'split'], and are linked to the front-end on each persons workstation [got
me, again; what does 'linked to the front-end on each persons workstation'
mean?

Thank you very much for taking the time to help.

I can't get MS Access into multi-user mode even though I have the DB set to
multi-user under Tools/Advanced. Please help. Thanks.

 

[Guest]

Joe.....

Thanks very much for taking the time to help. I really appreciate it.

investigator3707