472,968 Members | 1,653 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,968 software developers and data experts.

Access 2003 corruption: is this one salvageable?

DFS
"[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
Nov 13 '05 #1
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

Nov 13 '05 #2
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

Nov 13 '05 #3
DFS
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

Nov 13 '05 #4
DFS
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

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
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...
2
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...
8
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
0
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...
5
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....
2
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...
13
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...
2
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...
2
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...
2
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...
2
isladogs
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...
0
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...
4
NeoPa
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 :...
3
NeoPa
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...
0
isladogs
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...
3
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...
0
NeoPa
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...
3
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.