Question database opens read only on Windows 7 PC

mainlandd

New member
Local time
Today, 11:58
Joined
Apr 2, 2010
Messages
5
I run an Access 2000 database over a network with five pcs with different operating systems. On two of the machines which are running Windows 7, the database opens read only. The database is split and I am unable to link the back end tables due to the read only situation. Any help would be greatly appreciated.
 
The back end resides on a PC on the network. The network started as a peer to peer. I am not very well versed in networking especially after introducing Win 7 machines into the mix. The network works so I just go with the flow in that regard.
 
The front end resides on each PC on the network. The network started as a peer to peer. I am not very well versed in networking especially after introducing Win 7 machines into the mix. The network works so I just go with the flow in that regard.
 
What is the FILE PATH where the frontends reside? There are some that are "off limits" in Windows 7 so you need to have them not in those places.

Also, do the employees ALL have read/write/delete rights on the folder on the network where the backend is located?
 
The file path is something like frontdeskPC\\C:\data\xxx.mdb. I do not use computers on a daily basis anymore and I'm rapidly falling behind the times. As a result I am unfamiliar with windows 7 and its 'trusted files'. I suspect that my problem is somehow related to some nuances of Win 7 but I don't have a Win 7 machine at my immediate disposal to play with. You continued guidance is greatly appreciated. Thank you.
 
The other question -
Also, do the employees ALL have read/write/delete rights on the folder on the network where the backend is located?

They all need read write delete rights as that can affect if it opens read only as well.
 
As far as I know (with limited networking and permissions knowledge in Windows 7) all have the needed permissions. I will check the settings in the near future and get back to you if I need further clarification on the issue. Thanks for your help.
 
Mainland

You can test out whether a computer has read write permission to a folder yourself by trying to save a text file to that folder from the computer in question.
 
it is probably the c: folder and subfolders.

not every programme can write directly to a c: folder, as I am finding out now!

something to do with administrator privileges etc. possibly hard or awkward to fix, though
 
Mainland

You can test out whether a computer has read write permission to a folder yourself by trying to save a text file to that folder from the computer in question.

That is not completely accurate. The security is based on WHO is logged into the computer, not WHICH computer it is coming from. So one person can do it from the same computer someone else can't. So the test is whether each person can create and then delete the file in that folder.
 

Users who are viewing this thread

Back
Top Bottom