Permanently hide table

[Boon]

Hello,

I am creating a standalone Access application. I save the application as
..mde. How can I hide the table so that people will not see them. I want to
permanently hide them. Is there a way to lock, or encrypt the table? To be
clearer, I want users just click on the form and have no access to tables.

Thanks a bunch

 

[Chris O''Neill]

Hello,

I am creating a standalone Access application. I save the application as
..mde. How can I hide the table so that people will not see them. I want to
permanently hide them. Is there a way to lock, or encrypt the table? To be
clearer, I want users just click on the form and have no access to tables.

I'm not really sure what you're trying to do, but you can "hide" a table in
a database by giving at name starting with "Usys" (e.g. UsysMyTable). Then,
it won't show up in the Database window. You can also encrypt the database
(Tools --> Security --> Encrypt/Decrypt Database). Finally, you can setup
Access security so that only you (or anyone else you choose) will have access
to the table(s). This includes granting privileges to open form(s) but deny
access to tables. For more info on how to setup Access security, see the FAQ
here:

http://support.microsoft.com/kb/207793

Thanks a bunch

You're welcome. If you provide more specific details of what you're trying
to do, you'll probably get more detailed help. in the meantime, I hope this
helps...

Regards, Chris

 

[Boon]

Thanks a lot for your answer Chris. It gives me lots of ideas.

I am using Access2007 to create this application. The application is a
standalone application, one file. I want everything to be in one Access
file. My goal is if I am the one who open this file, I will see everything
in Access and of course able to momdify them. If others open this file, they
would not be able to see anything except the main form.

Is it possible to create a prompt for username and password? I am thinking
that if the user put in the username/password as admin/admin, he will get
full access, if the user put in the username/passeword as user/user, he will
see only form and has NO access to tables.

Thanks,
Boon