Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

msaccess.exe - Application Error HELP!!!

Status
Not open for further replies.

jedel

Programmer
Jan 11, 2003
430
AU
Can anyone explain to me what this eror means. I have just spent near two months creating a databse in 97, only come up with this error and the inability to open the database. Puhleeease tell me it has nothing to do with my db and only somethinf to do with MS Access... Here is the error:

The instruction at "0x6512c463" reference memory at "0x08ddfc00". The memory could not be "read".

What can I do....

Jedel
 
This is a windows OS error, used to be known as a gpf.

With Access, I've noticed it happen for 2 reasons (although there are certainly many more).

First, a query that is joining on type-mismatched fields has caused this for me. Second, running the SHOWPLAN utility can cause this, usually for similar reasons--when showplan is trying to analyze a query with some sort of illegal, but often allowed, join.
--jsteph
 
jsteph,

Although I do have queries. I didn't change any of the structure of the database when it went down. ie I was working on the reporting side of things. when I re opened it, the error came up. I tried opening some other databases. Some opeded and others didn't. We are having some issues with the network. I think It copped a lighting stike last weekend in Canberra, so the system in slow.

If the query is the issue, How did you fix it?

Jedel
 
If it's not a new change, then it's probably not one of the queries--you'd notice that right away when you change it. These problems are extremely difficult to track down. The Network issue is a red flag, of course. Did you start getting this message after the network issues cropped up?

Another thing to look at is tables in which you've opened and then sorted or filtered--then said 'yes' when it asked if you wanted to save the chagnes to the table. This saves the filter/sort and every time you open the table it's running a filter or sort.

When exactly does this error come up? Just on opening the db? What if you hold down the Shift key while opening (to bypass startup macros/forms, etc)?

If it just crashes on opening the .mdb file alone, try to repair it, by selecting Repair from the tools menu before you open any db, then browse to the db in question.
--Jsteph
 
Unkown.

AS it turns out, it was the database that was corrupted. I tried everything to get it back. I repaired, compacted, Held the shift key. You name it. I even created a new db and tried to import the tables, queries etc. It would not import the forms or the modules. So no matter what I tried, I could not open it.

I turned to the internet, Google groups and the like. they speak about how to recover corrupt databases, but they only spoke of corrupt databses once they were open. So unless there is an application, or utility that can improve the repair function, that db was gone for good!

There is an upside. The network administrators take and image every night, so it was a fairly simple matter to get the image from two nights ago and replace it (PHEW!). Only lost a days work.

Huge lessons learnt here.

1. try and find better ways to recover corrupt databases, and

2. BACK UP BACK UP BACK UP!!!

Thanks for trying to help. If you do know of any utilities that improve the repair function, please, post them here, I have this post email notified. I'll do the same.

Thanks again

Jedel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top