monitor viewing of VBA code.

[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

 

[Ron Hinds]

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

 

[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

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]

 

[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

 

[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

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]