Dbase Network Question

[gwmurray]

Hi folks, i've been working on a dbase for a few weeks now. I wanted to
run the DBASE plan by you all and make sure that my goal is
achievable...

It's a health assessment tool dbase. Holds client health data. We have
about 5 or 6 RNs/Nurses in our office that will be assessing client
health issues and putting them in under this database... My question is
each of them have their own computer... Each of them will have Access
2002 on their computer. I will want this database to be networked and
accessed by all 6 employees at the same time and each of them be
working on individual records or some possibly the same record.

Is this possible? And what specifically do I need to know about the
networking? Do I just share the .MDB file on the server and have them
just double click on the shared file and that's it?

Thanks!!

 

[___]

You'll need to create a back end db to store the tables and the fron
end should be on each users pc. All front end db's should only contai
the forms, queries etc. and be linked to the tables in the back end d
over the network. You shouldn't have any problems doing it this way.

HT

 

[gwmurray]

Thanks for the reply, it makes since! Is there any article or info where
I can go that will tell me how to link front end forms to a backend
database? Or is it as simple as just copying the forms to a new mdb?

Thanks!!

 

[___]

After making a backup of your db, It should be as simple as...

1. Copy your main db to a shared folder on the the server.
2. Create a new blank db on one of the users pc's.
3. Import all forms, queries, reports etc into the new db leaving out
the tables.
4. Once all is imported, right click in the blank Tables section of the
db and select "Link Tables". Select your main db from the server and
pick the tables you need to link.
5. Test all works ok
6. Do the same to the other 4 users pc's
7. Go to pub, job complete!

HTH

 

[gwmurray]

You're the best! THANKS!!!!!

 

[___]

You're welcome