monitor viewing of VBA code.

S

stoppal

I have a bunch of code in VBA.

I have locked it and want to make sure no one can use ever view it. If
someone cracks my password and opens my VBA code, I would like to know
the IP address. Is there a way to program my .mdb file so that when
some opens the code, a script gets run? (for example, sending a email,
or a net send "code opened").

thank you
 
R

Ron Hinds

Why don't you just compile it to a .mde, then the code won't be viewable by
anyone.
 
J

John Vinson

I have a bunch of code in VBA.

I have locked it and want to make sure no one can use ever view it. If
someone cracks my password and opens my VBA code, I would like to know
the IP address. Is there a way to program my .mdb file so that when
some opens the code, a script gets run? (for example, sending a email,
or a net send "code opened").

thank you
Click to expand...

Better: use the Tools... Convert menu to make a .mde file, and make
that available on your public view. Keep the .mdb file on a CD in a
locked desk drawer.

Then the code *will simply not exist anymore* in the database
accessible to users, so the problem will not arise in the first place.

John W. Vinson[MVP]
 
S

stoppal

thanks!

GREAT IDEA! I did not know you can do that.

I tested and it worked. But what about all the reference files? When
I took the MDB file to a new computer I always had to resetup the
reference files. Do I need do do this with a MDE file, or are all the
reference files compiled into the new file?

thanks
 
J

John Vinson

thanks!

GREAT IDEA! I did not know you can do that.

I tested and it worked. But what about all the reference files? When
I took the MDB file to a new computer I always had to resetup the
reference files. Do I need do do this with a MDE file, or are all the
reference files compiled into the new file?

thanks
Click to expand...

References are just that - references to external programs, not part
of Access. See the suggestions at
http://home.bendbroadband.com/conradsystems/accessjunkie/references.html
for how to manage them.

John W. Vinson[MVP]
 
Top