"[database name] has detected corruption in this file. To try to repair the
corruption, first make a backup copy of the file. Then, on the Tools menu,
point to Database Utilities and click Compact and Repair database. If you
are currently trying to repair this corruption then you will need to
recreate this file or restore it from a previous backup."
I think it's my usage of the Excel 9.0 object library that's causing the
problem, but I can't be sure.
It's a corruption in one or all of the modules. None will open.
I can put forms in design mode, but can't add objects to them. I can
sometimes open tables.
None of the usual repair / recovery methods works:
* Compact and Repair
* create new db and import objects
* delete non-corrupt module, Compact and Repair
* export modules to another file
Any ideas?
Thanks 4 4576
Try call Access using the (undocumented or supported I think) /decompile
switch (still in AC 2003?) on a COPY of your database
For a while, I had to do this so much I created a shortcut while developing
that did it for me, whose target was:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /decompile "H:\My
Documents\project\foo.mdb"
Good luck
"DFS" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com... "[database name] has detected corruption in this file. To try to repair
the corruption, first make a backup copy of the file. Then, on the Tools
menu, point to Database Utilities and click Compact and Repair database. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup."
I think it's my usage of the Excel 9.0 object library that's causing the problem, but I can't be sure.
It's a corruption in one or all of the modules. None will open.
I can put forms in design mode, but can't add objects to them. I can sometimes open tables.
None of the usual repair / recovery methods works: * Compact and Repair * create new db and import objects * delete non-corrupt module, Compact and Repair * export modules to another file Any ideas?
Thanks
Best information and links on corruption and trying to fix it that I know
about are at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.
Take a look at those.
I never heard of using an Excel library of any version causing database
corruption. There are many causes, but that'd be a new one on me.
Larry Linson
Microsoft Access MVP
"DFS" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com... "[database name] has detected corruption in this file. To try to repair
the corruption, first make a backup copy of the file. Then, on the Tools
menu, point to Database Utilities and click Compact and Repair database. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup."
I think it's my usage of the Excel 9.0 object library that's causing the problem, but I can't be sure.
It's a corruption in one or all of the modules. None will open.
I can put forms in design mode, but can't add objects to them. I can sometimes open tables.
None of the usual repair / recovery methods works: * Compact and Repair * create new db and import objects * delete non-corrupt module, Compact and Repair * export modules to another file Any ideas?
Thanks
Malcolm Cook wrote: Try call Access using the (undocumented or supported I think) /decompile switch (still in AC 2003?) on a COPY of your database
For a while, I had to do this so much I created a shortcut while developing that did it for me, whose target was:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /decompile "H:\My Documents\project\foo.mdb"
Good luck
Thanks, but no cigar. Same error.
"DFS" <no****@nospam.com> wrote in message news:10*************@corp.supernews.com... "[database name] has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair database. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup."
I think it's my usage of the Excel 9.0 object library that's causing the problem, but I can't be sure.
It's a corruption in one or all of the modules. None will open.
I can put forms in design mode, but can't add objects to them. I can sometimes open tables.
None of the usual repair / recovery methods works: * Compact and Repair * create new db and import objects * delete non-corrupt module, Compact and Repair * export modules to another file Any ideas?
Thanks
Larry Linson wrote: Best information and links on corruption and trying to fix it that I know about are at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm. Take a look at those.
I never heard of using an Excel library of any version causing database corruption. There are many causes, but that'd be a new one on me.
Well, I had been working with and in a code block that uses the Excel
automation object when the corruption occurred.
Here's the automation code that runs fine once, but usually leaves the Excel
instance open in memory (use Task Mgr | Processes | End Process to close
it). The next time you try to run it, it crashes on
'objWB.Worksheets(1).Activate' (halfway down)
Dim objExcel As Excel.Application, objWB As Excel.Workbook, objWS As
Excel.Worksheet
Set objExcel = New Excel.Application
Set objWB = objExcel.Workbooks.Open(chosenFile)
For Each objWS In objWB.Worksheets
With objExcel
... do things with the sheet
End With
Next objWS
'LEAVE CURSOR IN A1 BEFORE SAVING SHEET
objWB.Worksheets(1).Activate
objWB.Worksheets(1).Range("A1:A1").Select
objWB.Worksheets(1).Range("A1").Activate
objExcel.ActiveWorkbook.Save
'CLOSE OBJECTS
Set objWS = Nothing
objWB.Close
Set objWB = Nothing
objExcel.Quit
Set objExcel = Nothing
Larry Linson Microsoft Access MVP
"DFS" <no****@nospam.com> wrote in message news:10*************@corp.supernews.com... "[database name] has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair database. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup."
I think it's my usage of the Excel 9.0 object library that's causing the problem, but I can't be sure.
It's a corruption in one or all of the modules. None will open.
I can put forms in design mode, but can't add objects to them. I can sometimes open tables.
None of the usual repair / recovery methods works: * Compact and Repair * create new db and import objects * delete non-corrupt module, Compact and Repair * export modules to another file Any ideas?
Thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: JK Peck |
last post by:
I have a fairly large Access application that ran correctly in Access
2000. After upgrading to Access 2003 (and recompiling and updating
references), it reliably crashes at a certain point. If I...
|
by: Jennifer B. |
last post by:
Hi Every Body:
I hope this is to the right post. I apologize if I am incorrect.
Could anyone please answer one or any of the following questions for
Access 2003:
- Maximum size of an...
|
by: pw |
last post by:
Hi,
I'd like to have each client record have a picture of themselves.
Any ideas on what the best way to do this in my Access 97 application?
Thanks,
-pw
|
by: Wayne |
last post by:
Can anyone cast any light on the following. I have a database that I
have written in Access 2003 using 2000 file format. Everything was
working OK when running it under Access 2003 but when I...
|
by: mr_mach7 |
last post by:
I have an Access database that needs to be compacted and repaired
almost on a daily basis. It is the front end that needs to be fixed, so
other users cannot get into it when the problem happens....
|
by: Frav |
last post by:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from...
|
by: Owen Jenkins |
last post by:
Following on from an earlier post...
I can reliably corrupt a record by doing the following ...
Open two separate but identical front ends on one PC each linking to the
same back end.
Edit a...
|
by: suzanne |
last post by:
I have a database that had been stable until 3 weeks ago. The Access
2003 database occasionally (a couple of times a week) gets corrupted
when the last user exits the application. At least, that's...
|
by: Access |
last post by:
Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? I've been experiencing corruption problems with a
particular database. I've tried copying all the objects into a...
|
by: DJRhino |
last post by:
Was curious if anyone else was having this same issue or not....
I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |