Database Question

[Guest]

Is there anyway to have a database that the only thing that people can access
are the forms? I don't want anyone to be able to get to the tables, queries
or anything like that. I want them to bring up the database and just input
the information.

 

[Guest]

Yes, Create a database with links to the tables, in the table properties, set
them to hidden, then create an autoexec macro that will bring up your form
when the database is opened.
let me know if this helps.

 

[Guest]

Is there anyway to hide all the tables at once or do I need to do it one at a
time?

 

[Guest]

Unfortunately one at a time.

Is there anyway to hide all the tables at once or do I need to do it one at a
time?

 

[Albert D. Kallal]

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Guest]

I would love to download because that is exactly what I need to do, I want
the the whole interface hidden, but since I am at work I can download on to
the PC - is there another way I can find out how to do it.