access forms open as program

[Joe Farage]

Is there any way to have Access open the forms that were created and to hide the actual Access program?
For instance, when the user opens the database, it is set up to automatically open a certain form. But they can still see and open all the tables and everything because Access opens behind it. Is there a way to get around this or any suggestions to accomplish what I'm trying to accomplish?

[pod]

but of course you can, and you could also only release a compiled version of the forms.

Check out the options under Tools -> Startup

In there you can uncheck features such as :
Allow Full Menus
Allow Built-In Toolbars
...

Also the tool under Tools -> Database Utilities-> Make MDE Files builds a compiled version of your forms.

And I suggest you read up on seperating your database tables from the forms; i.e. the tables in one file, and the Forms in another.

So you would give only access to the secured Forms hiding the location of the tables.

This also secures the data, in case the Form file gets corrupted, or lost. Also you can update the Forms as you wish, never having to worry about losing data, or updating the tables before you replace the form file, since the tables of data are sitting alone on the network hidden from the users.

You will have to learn about connection strings to connect through OLEDB to the database file, but you could also connect to other database such as Oracle, SQL, and whatnot.

I hope that answers your question

link on connection strings:
http://www.sqlstrings.com/SQL-Server...on-strings.htm