How do I set permissions to read all tables in access database....

[DMNCS]

I have created a query to read all the tables in an access database. I now get the error 'no read permissions'. I was using access 2003 and know how to set the rights to give this permission. Now that I have converted to 2007 I can not seem to find how to set the permissions.....

Could someone plz tell me how this is done in 2007.. thanks....

[June7]

Access 2007 doesn't have the security settings that were in 2003, other than a password for the database.

I just tested a query of the MSysObjects table and worked. Is that the query you are doing?

The project was built in 2007 and now running with 2010. Have no security restrictions, not even a password.

Did you import everything from the mdb into a new accdb file?

[DMNCS]

Access 2007 doesn't have the security settings that were in 2003, other than a password for the database.

I just tested a query of the MSysObjects table and worked. Is that the query you are doing?

Thanks,, problem resolved,,,,

I had the wrong query as well. Once I corrected the query everything started working. Thanks for pointing out the query issue...