Problem with secured MS access db
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?