Securing + FE BE?

[scouser]

Hello. I have just started work at a new company and have been asked to 'Network' 5 different DB's to enable multiple users (around 5) simultaneous access (Dept A - DBa / Dept B - DBb etc.....) Currently if User A accesses the DB User B gets read only access.

I have googled and also searched forum + read some posts here but have failed to answer my questions (Spilt Database / FE BE??).

I have also played with a copy of an existing DB to add security by way of Security Groups (Managed this!!).

A desktop shortcut was created:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\Philip Horan\My Documents\Access\FE BE\FE BE.mdb" /WRKGRP "C:\Documents and Settings\Philip Horan\My Documents\Access\FE BE\Security.mdw"

Could I move files and manually amend to a unc path?
Advice, links to answers very much appreciated.
Kind Regards,
Phil.

 

[ghudson]

Each user must have full permission to the directory where the db is located. They need to be able to create/edit/delete files where the db is created for they have to be able to create/edit/delete the record locking file [YourDB.ldb]. Lots of information within the forum on your problem.

The answer to your second question is yes but do not forget to relink the tables.

Each user must have a copy of the front end installed on their hard drive and each front end must be linked to the one back end.

 

[scouser]

Thanks

Thanks for taking time to answer. I will keep searching regards splitting the DB.
Regards,
Phil.

 

[scouser]

May Help Others?

Guys I have found this link that helped explain it all to me

http://www.databasedev.co.uk/split_a_database.html

Phil.