Cannot open Access DB: You do not have the necessary permissions to use the object , have your system administrator or the person...

It sounds like you're managing to open the DB with your default mdw instead of the eggster one. You may need to open it with that, instead. You can create a shortcut which will tell it to open with the right MWD:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" "C:\eggster.mdb" /WRKGRP "C:\eggster.mdb.mdw" (assumes you have a standard install location for your Access executable)

-Rachel

I'm afraid I get the same error message :( I'm using access 2007.

Can you confirm that the person who gave you the files also stored them at the C: drive level? If not, you need to emulate the folder paths that s/he kept them in, and store your MDW there.

As an aside, if you're going cross version, i.e., it was designed in an earlier one, you may be SOL in terms of using the MDW.

Worst case is, there are MDW breakers out there, but I can't recommend 'em - once you break the egg (no pun intended on your DB name!), you can't unbreak it. However, if you're that level of desperate, a search for such products will likely help you out.

-Rachel

I'm pretty sure they weren't.. I didn't realize this was a requirement.. I'll learn the exact path and try it that way.

I did exactly as you suggested, but it still gives me the same error despite creating a shortcut and duplicating the path on the actual server.

Assuming the MDW and MDB were developed in 2007, too, the only idea I have left for you is to confirm both the login and password and specifically, their case sensitivity, which is relevant. (If the files weren't developed in 2007, that may be your issue. Otherwise, I'm out of ideas for you beyond a password breaker software, which I really don't recommend.

-Rachel

I installed access 2003 (where the db was developed) and nothing changed; where exactly do I enter the username and password? it doesn't prompt me anywhere?

Hmm. If you're not even getting to the actual login, this may be something even sillier than we've been trying, and not related to Access security. Please go to Explorer, find the MDB file, and right click on it. Check under Properties, and see if it's been set to Read Only. If it has, uncheck that. Do the same to the MDW, though this is less likely your issue. Then try opening again.

-R

they were not set to read only.

I just receive this message You do not have the necessary permissions to use the 'c:\eggster.mdb' object , have your system administrator or the person who created this object establish the appropriate permissions for you. what ever I do :(

Argh! Ok, here's another recommendation I saw relative to similar complaints:

"Open Access using the default system.mdw workgroup, start a new database,
and import all the objects from your 'secure' database. It will no longer
be secure."

Not sure if this'll work, but possibly it will just ask you for the user name and password you have, instead of telling you you can't.

You may also want to go back to the person who gave it to you and have them run a test whereby they copy the front end database to another location and try to open it - if they get the same error, it may be about how the permissions were created in the database on an object level.

Without hands on testing, I think I've reached the end of what I can suggest. Good luck!

-Rachel

I found the solution myself.