MDE security issue

[Guest]

I am converting data from one Access app to another. A contractor wrote a
utility (in Access) that sources the data from the legacy app through linked
tables. Queries are then run to convert the data into the table structures of
the new app. He was able to use this just fine. Everytime I try I get the
below error message. I assume this has something to do with the security of
the MDE but don't know how to get through this hurdle.

Thanks in advance,
Dave

Error msg:
You do not have the necessary permissions to use the 'C:\...' object. Have
your system administrator or the person who created this object establish the
appropriate permissions for you.

 

[Joan Wild]

I assume the 'C:\...' object is the path to the mde?

You likely are double-clicking that file when you get this message, meaning
you are using the standard system.mdw workgroup file that ships with Access
(it silently logs you in as 'Admin').

The contractor implemented user level security, and the 'Admin' user doesn't
have any permissions.

You need to open the mde while using the correct mdw.

I suggest you create a desktop shortcut with a target like:
"path to msaccess.exe" "path to mde" /wrkgrp "path to mdw"

You'll need a valid username/password to get in.