How to Hide Microsoft Access Database Design Buttons

[Sunnylei]

I want to protect my database after completing a database design. I know I need to create a switch board fist, however I don't know how to hide the design buttons. Can someone give me a tip

Thanks

Sunny

 

[Mr. B]

What version of Access are you using?

 

[Sunnylei]

What version of Access are you using?

.

Access 2007

 

[Sunnylei]

What version of Access are you using?

Sorry, I have two versions ie 2000, and 2007

 

[Mr. B]

First, make sure you are using the split front-end and back-end file method. This is where you have one database file that has nothing the the tables in it. This file is called the Back-end file. You then have another file that has all of your forms, queries, reports and modules in it. The tables in the back-end file are linked to the front-end file.

Using either version of Access, the simple way to protect your application from users is to make a compiled type file and let them use that version. This is referred to as creating an mde (accde in Access 2007)file. There is an option on the menu to perform this conversion. Just make sure you have a backup copy of your front-end file before you do this.

You will not be able to make change to the mde (accde in Access 2007), therefore, you would continue to make updates a fixes in your mdb file.

 

[Khalid_Afridi]

As explained by Mr. B, Access Database should be provided to the end user in Front-End MDE or ACCDE Format where they can put the data in a database through Forms. The Back-End (tables) should be kept separate from the end user and should be password protected.

Here is how to convert Access Database to MDE, or ACCDE file format:
Converting a Microsoft Access Database File to a MDE File or ACCDE File
What's an MDE?