Solved

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

Posted on 2011-03-25
11
324 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:ruavol2
11 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 417 total points
ID: 35217646
Start by adding a Password to your VBA project ... OR , create an ACCDE.  Either way prevents users from getting into code.

mx
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 417 total points
ID: 35217667
VBA Password:

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

mx
Capture1.gif
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 83 total points
ID: 35217673
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 417 total points
ID: 35217697
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 35220140
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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 417 total points
ID: 35220232
"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
 
LVL 100

Expert Comment

by:mlmcc
ID: 35220360
The ACCDB then has no code?

Can the ACCDE reside on the server and be shared?

mlmcc
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 417 total points
ID: 35220647
"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
 
LVL 100

Expert Comment

by:mlmcc
ID: 35220697
Thanks

That is just what we needed to know

mlmcc
0
 

Author Closing Comment

by:ruavol2
ID: 35234646
Excellent.....Thank you both very much.
0
 
LVL 75
ID: 35234666
You are welcome ...

mx
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question