Launching particular parts of Acess

[johnowens]

I want to be able to launch access from another software application so that only reports are able to be viewed, edited, or created. I dont want the user to have any access to any other sections of acess (tables, queries, forms, pages, etc). is this possible, and do you have any idea where i could find out how to do this?

 

[bobjames]

How would users be able to create reports if the they didn't have access to the tables or queries? I don't think they can.

 

[MHM]

There is more than one solution for you:

1. Just hide all other objects. Do this by right-click to database-window-objects and check "hidden".

2. Use the Access-built-in password-untility: You can restrict changes to certain users, although every user could see it.

3. Create queries which access the database containing the data (like [SQL]: SELECT FileNames.FileName
FROM FileNames IN 'c:\projects\pk\pkctr_Data.mdb';
)
That way the table "FileNames" does not appear in the database window - but the query works!

Hope this helps.

 

[bobjames]

The hidden property doesn't take away access to the object. You would have to use security to take away permissions not allow user access. If you wanted to you could secure tables and the create queries that your reports could be based on but these queries could inherit the owner's permissions through the run permissions property of the query.