Error when trying to access a file in a secure database

[Ken W]

I'm trying to use Access to write a report on files that are part of a secure
database. I have the authority, and therefore know the password and have a
user ID, to access the data conventionally through the program. However, when
I triy to link to this database, I get an error that "you do not have the
necessary permissions to use the 'xxxxxxxxxxxxxxxxxxxxxxx' object. Have your
system administrator or the person who created this object establish the
appropriate permissions for you.' Incidentally , I can access this file fine
in MS Query. How can I access it in Access?

 

[Joan Wild]

You have two simple choices:

1. Use the secure mdw while using your unsecured mdb. That way you'll be
prompted for a username/password and be authenticated to link to the secure
mdb/tables.

2. In the secure mdb, grant necessary permissions to the Users Group to
Open the database, and Read Data on the tables.