Protect DB

[hmongie]

Hi,

I'm not at all a professional db programmer. But, i have spent countless hours building a simple db. Can someone advise me on a few ways to protect my simple but eye burning, late night design and countless hours of work?

I'm just looking for a good way to protect the forms, reports and tables from being stripped and someone else reaping all the glory. Thanks everybody.

I haven't tried the mde but if there's more secure ways please let me know.

 

[ecniv]

First is the mde (since this runs but hides all code).

Shift lock (a property of an mdb/mde) stops users holding shift on loading the db which stops any forms/macros/code running. This property, when set, always runs the code/form/macro - good for start up stuff.

If you haven't utilised the menu much/at all, then loop through all the toolbars on the splash screen and disable them; no menu = no user prying.

If you feel people are likely to link to your tables, you have to use a workgroup file, should be done first as its fairly tricky to set up, but once it is set up right then no one can get to your db which our a user log on and password (The user bit could be held in a launcher mdb which copies the fe db from the shared area to the local drive and runs it using a couple of flags for user/password/no splash (ms access splash screen).


Vince

 

[hmongie]

thanx...

I'll try those.