Access Security

[DJ100]

Hi there,

I have a problem with Access Security . . . Using Access 2002 (XP) and trying to create a multi user database . . .

I have set up all my security (groups, users etc) and then split the back-end.

When I try to connect one of the workstations with just the forms etc on I am not managing to connect. I have tried the linked table manager and can not assign the links - something about not having the permissions etc.

I have looked at all the stuff regarding security already on here and can't see what I might be doing woring - although I haven;t yet created a new workgroup (which I am about to try now!)

If anyone has any ideas I would be really grateful - can't seem to get to grips with Access at all!!

Cheers

David

 

[The_Doc_Man]

When users access a database on a shared server, they have two sets of permissions.

The first is the workgroup security imposed by Access on its objects such as tables, queries, forms, etc. You have control of this through the Tools>>Security>>Permissions dialog box.

The second is the NETWORK security of the user who is now attaching to the shared area. That person needs the ability to do file create, delete, read, scan, and write in the shared directory. This is because whoever is first to connect to the DB has to create the .LDB file. Whoever is last to disconnect from the DB has to delete the .LDB file. Everyone needs to find, read, and update the .LDB file. Everyone needs to find, read, and update the .MDB file, too.

Make sure you have attacked both parts of this problem.

 

[DJ100]

Thanks for that . . .


I spent a couple of hours reading through all the stuff posted on security yesterday and have I think got it sorted

It appears that each machine is making its own .ldb - at least it shows one on the desktop when the app is running - is this right??

Cheers

David Jenkins