As executable as possible

[Tsango]

I am trying to make my database as secure as possible so I can sell the application I have written. Certian things are stored in a table to make the application unique to the buyer to hopefully stop free distribution.

So I need to make sure that the user cannot acces the tables and make changes to them other than via the front end.

I have a password protected backend but the users can still edit the contents of the table via the front end.

Not sure if this is the easiest way but I am considering the following:

I want to open the main form when the database is opened, and then close the whole access application when the main form is closed.

Also, is there a way to change the text in the Top Bar that says Microsoft Access to something else plus change the Tab Name on the Windows Program selection bar at the bottom of the screen.

Would using the Access Developer Extensions be the best answer to my problem??

http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx

Has anyone used these?

 

[Smart]

I want to open the main form when the database is opened, and then close the whole access application when the main form is closed.

To open the main form when openibg the database

Tools , startup
select your form from the display form/page dropdown box
deselect the display database check box (this will hide the the view of the tables queries etc)

To close the application whne exiting the main form

in the on close event of the form
type docmd.quit (as the last command)

 

[Kelemit]

In the same place that smart said...

You can change the App title as well as Icon... if you create it.

Tools -> Startup.

Application Title:

Application Icon:

Change to suite.

Kelemit

 

[Tsango]

Thanks guys

I take it you have to be a little careful here because once it is set up to open and close you can no longer edit it!!

 

[Kelemit]

wrong, you can still edit it.

All the menu bars etc are stil there. Unless you choose to have them ALL OFF.

ALso, shift when starting the database opens that DB window.

The best option you can have is to lock everything down so that nothing can open it, then have a administrator location where you can click on a preferably hidden location to open up the database for further editing.