Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Saved changes on forms and vb script revert back to original in access 2007

Posted on 2011-03-03
2
Medium Priority
?
366 Views
Last Modified: 2012-05-11
Dont know if anyone else has come across this problem (you have had to right?) but when I make a change in my vb script for an access form, it asks me to save the changes. I get the save dialogue to save changes for multiple items and I of course say yes. However, AS SOON AS I CLOSE THE FORM, the changes revert back to the original state. What is causing it to do this?
save-changes.png
0
Comment
Question by:jtovar3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 35032866
In many cases this is a sign of corruption. I'd do this:

1) Make a backup
2) Compact your databse - click the Office Button - Manage - Compact

If that doesn't work you can build a new, blank database and Import everything to that new database. To do that, after building the new db click the External Data tab group, select Access and Import everything into your new database. Make sure to remake any referneces, if needed.

If that doesn't work you may have an object that is corrupt. You can try a Decompile, which can sometimes recover these items. To do that, build a shortcut with this as the Target:

"full path to msaccess.exe" "full path to your databse" /decompile

Run this, and then open the database. Open the VBA Editor and click Debug - Compile. Fix any errors, and continue doing this until the menuitem is disabled.

After doing that, you should again Compact and Import into a New database, as described above.
0
 

Author Closing Comment

by:jtovar3
ID: 35037996
I think it had something to do with something being open. Your recommendation was excellent, but I managed to get by with closing everything and only editing the VB script and saving that. Weird.

Thanks!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

688 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