My Program For just MY Office

[austin3515]

Can I write some code where in the vba will check to see what the ip address is of the server holding the file, and disable it when being accessed from any other ip address?

Lately I've been thinking a lot about how someone could just walk out the door with years of my time invested in Access databases that are helpful to anyone in my industry. In fact I already know through the grapevine it has happened to me before...

And then too, I assume there is a way to lock up my code so no one can edit it?

 

[Micron]

I refreshed page when I didn't see my post, but it wasn't there so I posted again. Would remove this if I only could...

 

[Micron]

You can modify queries, macros and tables in an mde/accde but not forms, pages, reports or modules. The code is not viewable, so a password (that you can forget/lose) is not required. I wasn't sure if you were referring to a web domain or network. Once in my long tenure at a company, server and network upgrades did result in a new server name, which cause some overtime for us.