How do I stop users accessing my code/queries/etc

amorts

Board Regular
Joined
Jan 4, 2006
Messages
181
Hi,

I only want my users to be able to enter information onto the forms in my db. What is the best way to, 'lock down' everything else?

Thanks
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
Tools/Database Utilities/Make MDE File.

As previously stated, converting your MDB frontend to an MDE will prevent users from seeing what is behind the forms you present to them. It will compile the code, making it execute a bit faster also. (probably won't be able to tell though). The MDE uses the same data files (backend db) as your MDB uses.

The only drawback to an MDE is that every update you make to your MDB requires you create a new MDE.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
...Also,

You will need to do the following before creating the MDE --
1. Convert your database to the latest available format (XP and 2003 default to 2000 format: you MUST convert them to XP or 2003 before creating the MDE)

2. In the code environment, Debug > Compile [Your Project]. If it compiles, great. If not, correct any errors.

Also highly advisable if you haven't done it already, define a startup form in Tools > Startup, and hide the database window.

And ALWAYS keep a copy of the original database, for making design changes down the track. The MDE can't be unlocked (at least, not easily).

Denis
 

Forum statistics

Threads
1,141,625
Messages
5,707,470
Members
421,510
Latest member
haroonstr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top