Moving database to network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2003 "Sales Record" database. We will soon be changing our
computers to a network. What I would like to find out is how to convert the
database application to multi user. I assume that the database should be
split into data (tables) to be stored on the server and a copy the rest of
the objects (the application) to be store on each work station. How do I do
this?

Also, currently only one person can use the application a any one time
except for viewing some data in forms. Will this conversion allow multiple
simultaneous use of the application?

Thanks in advance
 
I have an Access 2003 "Sales Record" database. We will soon be changing our
computers to a network. What I would like to find out is how to convert the
database application to multi user. I assume that the database should be
split into data (tables) to be stored on the server and a copy the rest of
the objects (the application) to be store on each work station. How do I do
this?

Also, currently only one person can use the application a any one time
except for viewing some data in forms. Will this conversion allow multiple
simultaneous use of the application?
Click to expand...

Access is multiuser out of the box, unless you so something specific to make
it single-user (such as opening it exclusively).

See

http://www.granite.ab.ca/access/splitapp.htm

for instructions on splitting the app - your summary is precisely correct.

John W. Vinson [MVP]
 
Back
Top