Discussion Locked

Access MDB from a Windows 2000 Desktop

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am deploying Win 2000 desktops in an NT 4.0 PDC network where there is an Access 2000 created database residing on the NT4.0 PDC. Users including the network Administrator user can not open and run he Access database. Error is that user does nothave sufficient permissions. Ask the creater of the Object to grant premissions.

Any one have a solution to this?

5 replies

by cyan222

The problem probably lies with the permissions under Win 2000. If you want to fix the problem, under control panels go to Administrative Tools, and open Computer Management. Go to Local Users and Groups and select the user, right-click and go to properties. You will have to add the local user account to one of the NT Domain accounts. This is also called "Pulling down groups."
The reason it's not working is the local user account does not have rights on the network and you would have to add this to all local user accounts.

Hope this helps!

by curlergirl

Did this database possibly have an Access workgroup set up with security settings? If so, the workstations would have to join the Access workgroup before they would be able to open the database. You need to run wrkgadm.exe (shd be in \%systemroot%\system32 folder) and join the appropriate Access workgroup. Hope this helps!

This discussion is closed to new replies.