setting up a multi user database in access 97 database

[Guest]

Hello, My name is Edward Letendre. I have been working on getting a database
from access 2.0 to access 97. I am eventually going to move the database to
access 2000, but I hit a bit of a road block in that the code is so confusing
in certain places that I might just stay in access 97.

Anyway, at this point I want to get the database setup for a multi user
database instead of a single user database. As it stands now, there are
multiple user log ons to the location of the database but it is accessed from
a single database. What do I need to do to get it setup and rolled out as a
multi user database so that all users can access the same data from their
desktops.

Incase you wanted to know, the file that is accessed from the one computer,
is located on the network in a specific directory. I just need to know what
I should do at this point to at lease get it rolled out to other desktops. I
have the ability to install access 97 on other desktops, but most users have
access to access 2000 as an application on their computer.

Help me if you can.

Edward Letendre.

 

[Joseph Meehan]

Hello, My name is Edward Letendre. I have been working on getting a
database from access 2.0 to access 97. I am eventually going to move
the database to access 2000, but I hit a bit of a road block in that
the code is so confusing in certain places that I might just stay in
access 97.

Anyway, at this point I want to get the database setup for a multi
user database instead of a single user database. As it stands now,
there are multiple user log ons to the location of the database but
it is accessed from a single database. What do I need to do to get
it setup and rolled out as a multi user database so that all users
can access the same data from their desktops.

Incase you wanted to know, the file that is accessed from the one
computer, is located on the network in a specific directory. I just
need to know what I should do at this point to at lease get it rolled
out to other desktops. I have the ability to install access 97 on
other desktops, but most users have access to access 2000 as an
application on their computer.

Help me if you can.

Edward Letendre.

I suggest that you take a look into split databases. Each user can use
their own copy of the database on their own machine with all your forms,
reports queries and code and maybe some of the static tables. Then one
database on the server is used to warehouse the data. The users copies are
called front ends and they Link to the table(s) in the Back end database on
the server.

I would think you would want to create the front ends in Access 2000
before rolling them out. I would also update the back end to 2000 as well.

I suggest you may also want to look into user level security and make
sure you understand record locking to assure trouble free (well almost)
operations.

It's a big job, but much easier doing it now than trying to patch it
together later.