|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
User locked outare running access 2003 which has two users that are allowed to update. Then one of the users converts the database to access 2007 for all other users. Recently one of the users lost her PC so I had to jury rig another one until her new one arrives. One problem that she was having is that if she did not open access before the other women (The one in charge) she could not open it at all. There are no error messages. If the other woman closes access then the one with the make shift set up can open the database and work on it and so can the original user. If the woman with the makeshift PC opens access first then the other woman has no problems. They tell me that this was not the case before the inflicted users PC crashed. As far as I know nothing was changed at the server level so I think it must have something to do with group membership or some such. I am not up on my server side stuff so if anyone can tell me what to look for I would appreciate it greatly. Don't share the same mdb file. Split it into a front end and back end. Back
end (holds tables and relationships) goes on the network share and a copy of the front end (holds everything else and links to the tables) goes on each user's desktop. If that doesn't work, use a shortcut to open the front end db file. Target's like this: "path to msaccess.exe" "path to db.mdb" Chris Mootcat wrote: Show quoteHide quote >I am doing some work for a company that has a Windows 2003 R2 server. They >are running access 2003 which has two users that are allowed to update. Then >one of the users converts the database to access 2007 for all other users. > >Recently one of the users lost her PC so I had to jury rig another one until >her new one arrives. One problem that she was having is that if she did not >open access before the other women (The one in charge) she could not open it >at all. There are no error messages. If the other woman closes access then >the one with the make shift set up can open the database and work on it and >so can the original user. > >If the woman with the makeshift PC opens access first then the other woman >has no problems. > >They tell me that this was not the case before the inflicted users PC crashed. > >As far as I know nothing was changed at the server level so I think it must >have something to do with group membership or some such. > >I am not up on my server side stuff so if anyone can tell me what to look >for I would appreciate it greatly. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1 
Other interesting topics
Synchronizing secured replicas
Creating a custom encrypted file to use it as product key Security problem with Admin password How to Password for Open in Exclusive Mode Establishing a Password for a Delete Button user-level security and splitting database One-Step Security Wizard wont open file Access 2007 "compact and repair" asking password Logout/login w/o closing Access enabling macros |
|||||||||||||||||||||||
