Access Database Window

[cbe]

Is there a way to customise the database window in Access to let users have access to queries and forms only, therefore disabling tables, reports, macros, etc.

Thanks

 

[ecniv]

yeeeaahhhhsss... But you'd need to put it into a workgroup, which can be tricky, and still give yourself full rights of course!

Why queries?? You mean let the users create queries on your db!!??


Vince

 

[ghudson]

The users should not have access to the database window. They should be allowed to access the data from the forms.

Access security with workgroups and permissions is the best way to control what the user can access [or import from another database] so that your db and objects are protected.

Search this forum for more info.