Protect my database

  • Thread starter Thread starter Weeze
  • Start date Start date
W

Weeze

Hi There

I'm just finished developing my own database in access
2000, but my problem is that someone can still see my
coding i did in visual basic. I have a start-up form does
load and then after that the switchboard, but if your
close the switchboard you are at the window of ceating
tables, queries, etc. And this is where you can see the
code also. Is there a way that if the user close the
switchboard he must go out of the database and not to the
other window, but then i suggest that i can't give the
user the option 2 do queries hey?

Please don't give me websites or code to download cause
our servers isn't working properly.

Please help me.
Craig
...
 
Suggestions if you don't want to setup full blown Access security
In startup (under Tools) uncheck Display Database Window.
Hide all the objects in the database
Set a password on your modules (in the module - Tools - Properties -
Protection)
Custom menus
These are a few ideas that will stop people just happening to find things
but wont stop people who are really out to mess things up

HTH
 
You could also make an MDE file which will not allow anyone to see or view
or change your code. You can get the database window open, but you can't
modify the contents, only open tables, etc.

-Gary
 
Back
Top