How can we keep users out from the Debugging mode in Microsoft Access 2007 so they do not accidentally change any code

We have been having problems with users accidentally changing code in an simple Access database we designed. Users have sometimes gone in to put in information and gotten a debug message and they have been known to type in code not realizing they are typing in our code.

How do we keep users from doing this. Please advise. Thank you.
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Start by adding a Password to your VBA project ... OR , create an ACCDE.  Either way prevents users from getting into code.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
VBA Password:

VBA Editor >> Tools>> <YourProjectName>Properties>> Protection tab >> Lock For Viewing.  Enter your password.  DO NOT FORGET your password.

mx
Capture1.gif
0
 
peter57rConnect With a Mentor Commented:
The simplest approach is to convert your file to an accde or mde file depending on what you are using.  There is no code for them to look at.  You MUST keep your original mdb/accdb file to do changes to the application.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
One additional thing.

IF ... you include robust Error Handling in your vba code, for the most part, you can prevent the Debug option/window from occurring.  Let me know if you need more info on Error Handling ...

mx
0
 
mlmccCommented:
I work with ruavol2 on this project

How do you create an accde file?

Do I need to install anything extra when the accde file is installed on the user's server?

Does the accde file include the data?


0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"How do you create an accde file?"
See image.
"Do I need to install anything extra when the accde file is installed on the user's server?"
No.
"Does the accde file include the data?"
Ideally no. You should have a Split configuration. Front End with every thing except data tables - this is your ACCDE, a copy on each users workstation ... linked to a master Back End on the server - ACCDB.

mx
Capture1.gif
0
 
mlmccCommented:
The ACCDB then has no code?

Can the ACCDE reside on the server and be shared?

mlmcc
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"The ACCDB then has no code?"
Correct. Tables only.

"Can the ACCDE reside on the server and be shared?"

Definitely.

Start with this:

How to manually split a Access database in Microsoft Access
http://support.microsoft.com/kb/304932

Splitting Microsoft Access Databases to Improve Performance and Simplify Maintainability
http://www.fmsinc.com/MicrosoftAccess/DatabaseSplitter/Index.html


'Preparing Your Access 2003 Database for Deployment, Part 1
http://msdn.microsoft.com/en-us/library/aa662933.aspx

mx
0
 
mlmccCommented:
Thanks

That is just what we needed to know

mlmcc
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Excellent.....Thank you both very much.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.