Using multible computers with Access

[David Ehrenreich]

What is the best way to have a database when multible
computers will be using it. Their our 2 primary functions
for the database. One is to have students log into the
system, and the other is for proctors to pull up the
students infomation.

We have one login computer and several computers that
would be used for the proctors.

right now we have seperate mdf files on each computer with
the forms and queries in each file. The tables are linked
to one main mdf file?

Would it be better to have all the computers use the same
mdf file, or would it better to have one mdf and have
shortscuts on the desktops tops? Is their any other way?
I would like to find the best setup.

Thank You
David Ehrenreich

 

[Averil]

Hi David,

If you split your database (Tools > Database Utilities >
Database Splitter) you can have one central back-end (the
tables) stored on a server and then have the front-end on
each computer that uses the program. The front end stores
all other objects like forms, queries, reports etc.

See the help file for more information.

Regards,
Averil

 

[David Ehrenreich]

Hello,

Thank you for your help.

I have one question though. The front end, will I make a
copy of that file for each computer or will each computer
use the same file.

 

[John Vinson]

I have one question though. The front end, will I make a
copy of that file for each computer or will each computer
use the same file.

One for each computer.