Error storing Memo in MDB file

[Fla]

Good Morning,
I've got a program in VB.NET that stores a string informations in a
Memo field of a MDB file.
It happened few that I got an error because the MDB file became
corrupted.
I tried opening the MDB file using Access 2003, I got the messagge
#Error in the memo field.
This corruption makes the database unuseful for any SQL query.
Any suggestion?

Thanks in advance

 

[Tom van Stiphout]

On Wed, 18 Mar 2009 03:23:22 -0700 (PDT), Fla <[email protected]>
wrote:

Try Repair & Compact. If that does not help, you create a MakeTable
query and use it to export all data minus the bad record to a new
table, then delete the references to the table, delete the table,
rename the new table to the old one, and fix up the references again.

-Tom.
Microsoft Access MVP

 

[sloan]

1. Repair the MDB?

2. Stop using Access(JET database is a better term) and go to something a
little more robust like SqlExpress.

..............

 

[Jim Rand]

Create a brand new Access database and try importing all the objects
(tables, forms, reports, macros, modules) from the corrupted database.
Also, Access seems to have a problem with tables containing more than one
memo field.

 

[a a r o n _ k e m p f]

yes, moving to ADP is an awesome answer-- it will allow you to
preserve your existing forms and reports.. and leverage the worlds
most popular database (SQL Server Express)

 

[a a r o n _ k e m p f]

wow-- yet another excuse for jet corruption--- sounds to me like Jet
sucks a big fat one
wow-- yet another excuse for jet corruption--- sounds to me like Jet
sucks a big fat one
wow-- yet another excuse for jet corruption--- sounds to me like Jet
sucks a big fat one
wow-- yet another excuse for jet corruption--- sounds to me like Jet
sucks a big fat one
wow-- yet another excuse for jet corruption--- sounds to me like Jet
sucks a big fat one
wow-- yet another excuse for jet corruption--- sounds to me like Jet
sucks a big fat one