Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 427
  • Last Modified:

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
0
johnhardy
Asked:
johnhardy
  • 6
  • 5
1 Solution
 
jhanceCommented:
It's pretty clear that your user account lacks the permission to open this file and/or create a temp file in the folder where it is located.

Correct this situation and you will probably be able to open the file.
0
 
johnhardyAuthor Commented:
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.




0
 
five22bagsCommented:
Try joining the the proper Workgroup with the MS Access Workgroup Admin. If you're running Access 2003, it is in Tools -> Security -> Workgroup Administrator. You are looking to join System.mdw probably located in the same place as your database file.

If that is not the issue, try the actual permissions of the file in relation to windows. To do this, browse your PC for the MDB file, right click on it and select "Properties". Then in the Security tab, look for your workgroup/username in the list of users. If it is not there, that is the cause of you not being able to access it. There should be a button there to Add a user. It will prompt you to type in a user name. Type in your windows logon, and it should do the rest for you. If you do not require a ton of security, type in the word "Everyone" and it will not restrict access to anyone.

I am assuming that this DB was created prior to your XP reinstallation?
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
johnhardyAuthor Commented:
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.
0
 
five22bagsCommented:
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.
0
 
johnhardyAuthor Commented:
Thanks very much I will have a go!
0
 
johnhardyAuthor Commented:
Looks like a no no with that.

Either way it will not allow me to open the database.

0
 
five22bagsCommented:
Is it an MDT file or MDB file in the error message?
0
 
johnhardyAuthor Commented:
mdb
0
 
five22bagsCommented:
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.
0
 
five22bagsCommented:
When you created this DB, did you assign specific permissions? Did you impliment any kind of security at all?
0
 
johnhardyAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now