Solved

Corrupt Autoexec and Macro files

Posted on 2011-09-06
4
383 Views
Last Modified: 2012-05-12
Hello everyone,
We seem to have corrupt Autoexec and macro files in out current database. Is it possible to extract the Autoexec and Macros from the backup DB from 2 weeks ago and apply them to to current database? If yes, what are the steps to accomplish this?
Thanks in advance for any help or suggestions.
0
Comment
Question by:tesla764
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 36491695
1) Delete the suspect macros.
2) Compact & Repair the db.
3) Reopen, then See image ... and browse to the backup db ... then import the items you need
Capture1.gif
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
ID: 36495984
MX's posts presumes this, but just to be sure...
Make sure you have valid backups before you delete the originals...

;-)
0
 

Author Closing Comment

by:tesla764
ID: 36497079
Thanks for all your help.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36497152
Thanks but my post was just a footnote.

You can request that Mx get all the points for answering the question directly.

Simply click the "Request Attention" link and ask that MX be given all the points.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now