CDBException because access file table item have value like "#Error".

[vjshankwar]

Hi all,

i m using access with odbc connection and use CRecordset class,

some time the table item have value like "#Error".and if i want to try read this record than exception is generate here.

please tell me how can i remove this record or tell me anything else to handle this.

thanks in advance.

[ovidiucucu]

If a CDBException is thrown, means that something gone wrong either in database or in your code.
See CDBException::m_nRetCode for possible error sources.
First of all, you have to handle those exceptions, i.e. try and catch them to see what's going wrong and eventually, take a decision.

   try
   {
      // call some functions which can throw CDBException*
      // (methods of CDatabase, CRecordset and related classes).
   }
   catch(CDBException* e)
   { 
      e->ReportError(); // show what's going wrong.
      // ... something else that has to be done in case of error...
      e->Delete();     // delete exception.
   }

[VictorN]

... some time the table item have value like "#Error".and if i want to try read this record than exception is generate here.

please tell me how can i remove this record or tell me anything else to handle this.

And what is the field type where an item value is like "#Error"?
Is it your own database or a third party one?
Usually "#Error" means that something is wrong with a field or table or database design...

[vjshankwar]

e->ReportError(); gives error message "MFC Internal Error : unable to load error string from resource".

and the field type is Text and its my own access type database.

[VictorN]

Check the validation rule for this "Text" field, the texts in this field to have correct characters and length (BTW, what is the max allowed length for this field?)Do these texts UNICODE or ANSI?
What happens if you open this DB in Access data view: do you see tses "#Error" values somewhere?

[vjshankwar]

i m not set any max value for field, by default it takes 255 chars.

when i open the access file and the table has value display like #Error and when i select this row or column access file popup the error message "Not a valid bookmark"

please help me how can i do this.

[VictorN]

You must first of all find out the appearance of "#Error" in this Access table!

[vjshankwar]

You must firdt of all to find out the appearance of "#Error" in this Access table!

When I compacted/repaired it I received these errors in a table called MSysCompactError:

-1206 Could not find field 'Description'
-1053 Could not find field 'Description'

in a rep_table

please help me how can i resolve this and prevent to occur this error.

[VictorN]

Sorry, I never had (and never saw) those errors.
Use google search to find out possible ways to solve...
http://www.pcreview.co.uk/forums/acc...-t1081763.html
http://bytes.com/topic/access/answer...iring-database
http://www.google.com/search?sclient...&aqi=&aql=&oq=