Network permission and their effects on Access

[Len Boorman]

Think I have thought this one through but would appreciate all comments and thoughts

Acc97 database on Novell network.
Novell permissions set at Read and Write only

So when I open database it performs fine and closes fine it seems but

When the database opens an ldb file is created. Will this be deleted when I close the database because I do not have network delete permission for that location.!!!!!
I suspect not. My trials seem to confirm this but I am having a bit of trouble convincing a few others.

So if I then open the database "exclusively" , close it and leave behind the ldb I believe this will effectively stop anybody else opening the database because it believes it is already open in exclusive mode.

Thoughts and comments appreciated

Len B

 

[RaeH]

Len

You could check this by opening your DB then using Windows explorer to look at where your DB file is. Access will create a record locking file which you will be able to see.
When you close your DB file this record locking file will disappear.
Rae

 

[FLabrecque]

Try to open the database from a co-worker's workstation.

 

[IgorB]

Search "ldb viewer" on microsoft site.
They have download for executable file for it.One you open this file and browse to your database it will show you all users who run/use database.

 

[ghudson]

The .ldb file will not go away if the users do not have the rights to delete files in the directory where the db is located. You can simply open the .ldb file with Notepad.exe to view its contents. You will have problems with the db if the .ldb file is not allowed to be deleted when the last person exits the db.

 

[The_Doc_Man]

We have Ac97 on Novell.

Users of the DB require: Read Write Create Erase Modify File-Scan on the main DB folder and this must propagate to the contained files.

They do not need Access-Control or Supervisor rights.

These rights MIGHT need to be inheritable to subfolders if your DB will use subfolders as repositories for intermediate output created from VBA.

 

[Len Boorman]

Thanks for all of your comments

You have confirmd my thoughts.

All I need to do now is convince our network people to grant permissions as requested.

They limit erase/delete to nobody except themselves on public network drives if they can get away with it.

Again thanks for the comments.

len B

 

[The_Doc_Man]

They limit erase/delete to nobody except themselves on public network drives if they can get away with it.

In this case, they cannot get away with it. Blame Bill Gates for making Access work that way.

 

[Len Boorman]

Hey Doc_Man

I blame him for everything anyway, He was responsible for Blair wasn't he

Cheers

Len B