front end for read-only users on network

[selahlynch]

I'm using Access 2003.

I'd like to have two levels of users that can access my database. Ones that can read/write the data, and ones that can read only.

I have a network drive with a location that is accessible only to the read/write users, and a location that is accessible to all users.

I tried putting the back-end of the database on the part of the drive accessible only to read/write users, and putting a front end, with forms designed not to allow edits, on the part of the network drive accessible to all users. But this is not working.

Can anyone suggest a better way to handle this problem? How can I give some users read/write permission, and some users read-only permission?

 

[Freshman]

i suggest pointing both FEs to the same BE (not diffrent BEs at diff locatios) and then you create a "login" form where you handle permissions from there instead of doing it at server level.
I dont like Access's build-in security and levels so create my own table and form to do it.
You can then set your read-only or edit rights based on the logged-in user's level.
Hope it makes sense.