Possible database corruption

[jamesmor]

Hey guys, need some help with a DB that I believe is corrupt.

Here's the details:

DB - Access 97
vb.net front end
DB size - 15mb

I can write to the database, and I can read back most data from the database, however, I'm starting to have fields that can't be read from. I know that there's a value there, and I know what it should be. But it's not being pulled into the front end.

I've tried compacting/repairing. I've tried converting to an Access 2003 database. I've also tried creating a new database and importing the data.

Same issue each time.

I think it's the database itself as my development database works just fine.

My development db is only ~2mb at any one time because I don't keep a lot of records in it.

Any help would be greatly appreciated!

 

[jdraw]

Can you access the data you need with
-an Access query
-some vba code?

Question I have is - If you removed vb.net from the picture is the data OK?

 

[boblarson]

You most likely have a data corruption problem if you can import it to a new 2003 database and still have issues with the data. You will likely need to track down which record/records is/are the problem.

What I've done in the past is to run compact and repair and then go look for any records which suddenly don't have a primary key in the primary key field. Delete those and then it should be back to normal.

 

[jamesmor]

the data itself "looks" ok. I can open the tables and access it. I'll check for any weird records in a few minutes.

thinking about "upsizing" to a sql express db any pros/cons of doing that?

edit:

now the database won't actually let our vb.net app connect to it, we can only open in access.

 

[annieee]

For sure, importing the database components one at a time will help you identify the culprit.

 

[gemma-the-husky]

copy it before you do anything - as you may make the corruption worse.

look for strange data in some fields.