I wrote and Access DBase to run for my company, it tracks various data, and reports as you can imagine,
the set up is, all users have a client program, Written in Access, and this is linked to the Tables held on our Network drive,
each client then only queries the records when required, and opens the datatables only briefly, this is to prevent the tables becoming locked, when the user saves the record, it then uploads it back to the network drive via update query,
The Client is held on the HOME Folder in each user, normally I would make a unique C:\ location, but we are running Citrix, and all areas other than the Home Folder seem to be deleted on exit, at least thats what happened when I tried to store it anywhere else..
so, Tables on the network, Client in the Home folder(I guess Technically Network Too) and every now and then, like this morning all users, have access to the Network folders and their own Home folder open the file to this:
Microsoft Acccess Cant find the Database file 'P:\notificationtracker\notificationtracker.mdb."
Make sure the path/filename is correct
This happens if I run the Client from the desktop short cut, or the folder itself. the best our IT could muster was, someone was in the program already locking the tables..
this is not the case due to the setup Ive used.
If I open access and try to open the file using the SHIFT key method, it tells me the program is locked by another user..
has anyone Else had a similar experience with networking files, I did a quick google, and the results said it maybe something with the linking schema, but I cannot understand why this would affect the Shift key opening method.