2
Contributors
1
Reply
3
Views
4 Years
Discussion Span
Last Post by adam_k
0

Create a separate db with your data (you can password protect this) and link the tables from your environment db to that.
Password protect your VBA and when you are done developing go to Database Tools and use the option Make ACCDE.
This will create a copy of the db in a "compiled" state that nobody can access the design view or the code behind forms. So you need to keep a copy of your "development" db to yourself and make changes if necessary. Make sure you also keep a backup development db, as ACCDE won't return to a normal access db.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.