johnhardy
asked on
Access wiil not open
I have recently reinstalled access.mdb and now when I try to open a a database it tells me
You do not have the necessary permissions to use D:\aa etc
Have your system administrator or the person who created this object to establish appropriate permission for you.
This of course was me.
The help file says
You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)
You do not have the necessary permissions for the specified object. To change your permission assignments, see your system administrator or the object's creator
Can someone please help me.
Thanks
john
You do not have the necessary permissions to use D:\aa etc
Have your system administrator or the person who created this object to establish appropriate permission for you.
This of course was me.
The help file says
You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)
You do not have the necessary permissions for the specified object. To change your permission assignments, see your system administrator or the object's creator
Can someone please help me.
Thanks
john
ASKER
Thanks
The user account you refer to I take it, is the XP user account which I use to logon to the PC with.
If so this is the same name and passwpord as its always been.
However I had XP reinstalled yesterday also a new version on NAVirus.
The user account you refer to I take it, is the XP user account which I use to logon to the PC with.
If so this is the same name and passwpord as its always been.
However I had XP reinstalled yesterday also a new version on NAVirus.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
"Try joining the the proper Workgroup with the MS Access Workgroup Admin"
That help a lot!
I have several copies of that database and they all began to work OK with the exception of the one I need.
On that DB I still get the message:
You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
I have checked all of the Security permissions and they all seem OK and I have given Full Control not inherited
So it seems like it just that one table now.
"Try joining the the proper Workgroup with the MS Access Workgroup Admin"
That help a lot!
I have several copies of that database and they all began to work OK with the exception of the one I need.
On that DB I still get the message:
You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
I have checked all of the Security permissions and they all seem OK and I have given Full Control not inherited
So it seems like it just that one table now.
For table-specific permissions, open your database, go to Tools -> Security -> User and Group Permissions
There you can view each database object, its owner, and its permissions to other users and groups. That should straighten you out.
If you are even still having trouble with that, I suggest creating a blank database, then importing all of the database objects using File -> Get External Data -> Import. This will give you a fresh copy of your DB with whatever permissions are active on your current machine.
There you can view each database object, its owner, and its permissions to other users and groups. That should straighten you out.
If you are even still having trouble with that, I suggest creating a blank database, then importing all of the database objects using File -> Get External Data -> Import. This will give you a fresh copy of your DB with whatever permissions are active on your current machine.
ASKER
Thanks very much I will have a go!
ASKER
Looks like a no no with that.
Either way it will not allow me to open the database.
Either way it will not allow me to open the database.
Is it an MDT file or MDB file in the error message?
ASKER
mdb
It appears you have created this database using a different MDW file. Run a search on your PC for all MDW files. Try using the Workgroup Administrator I mentioned before and joining each of these one by one then trying to open the database.
If you have created this DB prior to reloading xp on your machine, and have lost the MDW file, I am currently looking for workarounds for you.
If you have created this DB prior to reloading xp on your machine, and have lost the MDW file, I am currently looking for workarounds for you.
When you created this DB, did you assign specific permissions? Did you impliment any kind of security at all?
ASKER
Thanks very much,
All other db's are working fine and I have now downloaded a replacement from the web.
I think we can say a good job done.
Thanks so much for the great help.
Regards
John
All other db's are working fine and I have now downloaded a replacement from the web.
I think we can say a good job done.
Thanks so much for the great help.
Regards
John
Correct this situation and you will probably be able to open the file.