I have an issue on a user's PC which is causing knock-on effects for an in-house Access Database. I have investigated and I’m 99.9% certain the issue is with security setup in Access 2000. When Iaccess the menu option Tools > Security > User and Group Accounts - all the information is blank.
From looking at my PC and other users who work near them this person should see a default user of Admin and the Groups - Admin & Users available. I could create a new user but I won’t be able to add them to a group due to nothing being shown in “Available Groups”. I have since tried copying my own workgroup file (.mdw) to their PC and running the Workgroup administrator to join this file but it’s made no difference.
I tried running wrkgadm.exe from Start > Run on their PC but it states it can’t find the file. I don’t think there’s relevance in this as another user gets the same message but has no problems running the Access database.
And a final test is if I attempt to create a blank database on the local C:\ I get the error message “Cannot update. Database or object is read only”
I am a little perplexed on how to fix this, last resort could be to re-install Access 2000. As stated I’m sure this is a security issue but I don’t know how to restore “default” settings as I thought the Workgroup Administrator would do this?
Any suggestions/help would be grateful.
From looking at my PC and other users who work near them this person should see a default user of Admin and the Groups - Admin & Users available. I could create a new user but I won’t be able to add them to a group due to nothing being shown in “Available Groups”. I have since tried copying my own workgroup file (.mdw) to their PC and running the Workgroup administrator to join this file but it’s made no difference.
I tried running wrkgadm.exe from Start > Run on their PC but it states it can’t find the file. I don’t think there’s relevance in this as another user gets the same message but has no problems running the Access database.
And a final test is if I attempt to create a blank database on the local C:\ I get the error message “Cannot update. Database or object is read only”
I am a little perplexed on how to fix this, last resort could be to re-install Access 2000. As stated I’m sure this is a security issue but I don’t know how to restore “default” settings as I thought the Workgroup Administrator would do this?
Any suggestions/help would be grateful.