Sharing only forms, not tables

[mezzanine1974]

I have an access database. I have designed several forms which shows
information retrieved by querries. I would like to share this forms
with my colleagues via server. But, i dont want my colleagues to
access tables and querries, because of security reasons.
Could you pleae tell me a good reference to do that? How can i keep my
tables in a seperate place than forms.
Thanks

 

[Allen Browne]

That's not going to work.

Forms have no data of their own.
They read their data from and write their data to tables.
If your users have not rights to read or write the tables, your forms won't
work either.

 

[John W. Vinson]

I have an access database. I have designed several forms which shows
information retrieved by querries. I would like to share this forms
with my colleagues via server. But, i dont want my colleagues to
access tables and querries, because of security reasons.
Could you pleae tell me a good reference to do that? How can i keep my
tables in a seperate place than forms.
Thanks

You can - and should - use the Tools... Startup options to turn off
"View Database Window". You very well may want to create a limited
customized menu bar/toolbar, make it the default, and turn off the
built in menus as well. You will also need to implement database
security. Get the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Read it - CAREFULLY. Follow its instructions - EXPLICITLY. It's easy
to do security incorrectly!

As Allen says, you'll need to leave the users update and read rights
to the tables (otherwise the forms will be of no use to them), but you
can set up the user interface so there is no way (short of using
hacking techniques to break your interface security) to *see* the
table datasheets or design windows.

Getz and Litwin's supurb _Access <version> Developer's Handbook_ has
an entire chapter on preparing a database for distribution. Check your
Access references, most good books will at least touch on the subject.


John W. Vinson [MVP]