Film, Media & TV0 min ago
Access Permissions
4 Answers
Can anyone help - We have an access database and the employee who was in charge of it has left however he has maliciously changed the Permissions on the database which means we can view it but cannot edit it
Any Ideas
Answers
1 to 4 of 4
Best Answer
No best answer has yet been selected by smiler.iraq. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Try not to upset your staff and make sure that 2 people know all the passwords. Its common practice in I.T. when people resign to show them the door straight away. Not a sure fire was to stop this but helps. Theres simply no point having a password system which can be broken so you a bit stuck, can you export the data and the rebuild the database. You could threaten to take the former employee to court for crimial damage and see if he cracks.
Try holding down the shift key when you enter the database. Failing that there are programmes out there that can find lost passwords. Here is one for example
http://downloads-zdnet.com.com/3000-2092-10231676.
html?tag=lst-0-12
They are all pretty pricey though - as one would expect.
http://downloads-zdnet.com.com/3000-2092-10231676.
html?tag=lst-0-12
They are all pretty pricey though - as one would expect.
Does it ask you for a username/password to access the database? If yes: use the administrators account and see if you can adjust it. An alternative is to retore the database from a backup created before the permissions were changed. If not then the permission may have been set at the NTFS/share level. This is very easy to reset if you know the administrators account password.
1 to 4 of 4
