MS Access in multi-user mode..

I

investigator3707

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.
 
A

Arvin Meyer

investigator3707 said:
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
 
I

investigator3707

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.
 
A

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


investigator3707 said:
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.


investigator3707 said:
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.
 
I

investigator3707

Joe.....

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

investigator3707
 
Top