Sharing only forms, not tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mezzanine1974 - 06 Mar 2007 06:27 GMT

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

Reply to this Message

Allen Browne - 06 Mar 2007 06:51 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have an access database. I have designed several forms which shows
> information retrieved by querries. I would like to share this forms
[quoted text clipped - 3 lines]
> tables in a seperate place than forms.
> Thanks

Reply to this Message

John W. Vinson - 06 Mar 2007 17:16 GMT

>I have an access database. I have designed several forms which shows
>information retrieved by querries. I would like to share this forms
[quoted text clipped - 3 lines]
>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]

Reply to this Message