Error on Inserting to Ms Access Database (Unspecified Error \r\n Object invalid or no longer set)

Question

I want to insert about 2000 records every time a button is clicked. It works fine until record 511, and throw this exception: Unspecified Error \r\n Object invalid or no longer set

I've debugged it several times with different records or different order and always get the same error on 511th record. What's happening?

CODE: (I read the ID of the last record, before i insert another one)

string CmdText = "SELECT TOP 1 Id FROM MyTable ORDER BY Id DESC";
OleDbCommand com = new OleDbCommand(CmdText,tran.Connection,tran);
com.CommandType = CommandType.Text;
OleDbDataReader reader = com.ExecuteReader(); //exception started here

i think The foreign key of the table is an integer. Microsoft Jet is converting it to a decimal, and this causes the error in the query.add your table stracture — KF2
– KF2, Commented Apr 4, 2013 at 7:32

KF2 · Accepted Answer · 2013-04-04 07:42:16Z

1

It sounds like somehow the Jet engine is not working properly or is corrupted.

When opening and closing connections or recordsets using the Microsoft ODBC Driver for Access or the Microsoft OLE DB Provider for Jet, the following error may be reported:

Object invalid or no longer set.

To resolve this problem, install the latest Microsoft Jet 4.0 service pack 6. For additional information FIX: "Object invalid or no longer set" Error with Microsoft Jet

answered Apr 4, 2013 at 7:42

KF2

10.2k8 gold badges46 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

KF2 Over a year ago

I didn't try it before but it might be helpful,the error may says some thing is not correct in Jet engine.

ricojohari · Accepted Answer · 2013-04-04 07:56:59Z

1

I've figured it out guys. I have to close OleDBDataReader every time i want to insert new record.

Now it works fine. Thanks.

answered Apr 4, 2013 at 7:56

ricojohari

1831 gold badge3 silver badges13 bronze badges

Comments

user4726758 · Accepted Answer · 2015-03-29 15:46:03Z

0

The best way to resolve this problem is to delete that table in which its giving error in inserting / updating. and then re-create the table, but be sure, to backup the table data first.

answered Mar 29, 2015 at 15:46

user4726758

1

Collectives™ on Stack Overflow

Error on Inserting to Ms Access Database (Unspecified Error \r\n Object invalid or no longer set)

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related