Problem with secured MS access db

Erin · 16 June 2009, 08:49

I'm having a bit of trouble with our company database when trying to access it over the network. The main db resides on our 'server' pc with a workgroup file which holds all the permissions. Until recently I could access it from any pc on the network using the appropriate shortcut which also referenced the workgroup admin file.

Since recently compacting the db (and making a couple of minor changes to permissions) I can't gain access from any networked pc. I get a message saying 'the file cannot be found'. It does exist (bloody microsoft) and it is all spelt exactly correctly, but all remote pc's fail to open the file. I can find the file by using windows explorer from all remote pc's, but of course it won't open just by clicking it because of the security settings.

Any thoughts as to why the shortcut can't see the db file?

Cheers
Keith

DJL · 16 June 2009, 14:39

Quote:

Originally Posted by Erin

but of course it won't open just by clicking it because of the security settings.

Any thoughts as to why the shortcut can't see the db file?

If you can't open it by clicking it in Windows Explorer, then the shortcut isn't going to work.

What permissions do you have on the file/folder at the moment? (You can run "icacls filename.mdb" to get a text list you can post here)

Erin · 16 June 2009, 15:18

Quote:

Originally Posted by DJL

If you can't open it by clicking it in Windows Explorer, then the shortcut isn't going to work.

The shortcut would normally work because it includes the /wrkgrp switch to locate the security file containing the permissions. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "Z:\General\Database\Index08sec.mdb" /WRKGRP "Z:\General\Database\Secured.mdw"

Will try icacls. Not that I've heard of it before.
Thanks

Bigmuz7 · 20 June 2009, 22:52

Has any of the machines, or server been upgraded to Vista during this problem ocurrence, as all the permissions are a whole new ball game after this ?

Erin · 22 June 2009, 08:54

All run XP.

Managed to solve the problem on friday by chance. Thought I'd just try dropping the .mdb file into another directory. Did this and suddenly all PC's were able to see it. Must have been some problem with having deleted the original and then renaming the replacement with the old name. The registry or whatever must have lost track of the file and thought it no longer existed.

Thanks for the assistance though