Reserve Error

[Jaxson22]

I am in a table, and I am trying to edit data in one particular field.
When I move off the record, I get this error:
Reserver error (-1601);there is no message associated with this error.
I click ok - and it says this:
Reserved error <Item>; there is no message for this error. (Error 3000)
An unexpected error occurred. The specified code identifies the conditions under which this error can occur. Please contact Microsoft Product Support Services for more information.

Any ideas? This is the only record that this error will come up with. All others are fine.

Thanks!

 

[JeremyNYC]

Sounds like the database is corrupt. Delete the record. Compact and repair. Put in a new record to replace the old one (you can do an insert query, if you need to assign a particular autonumber to the record).

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[Jaxson22]

I wish I could! I can't even delete the record!

 

[JeremyNYC]

Hmm. Try creating a new table and appending all the records except that one.

Actually, you might first try importing the table into another database and checking whether or not the corruption follows the table. If not, you might be able to just reimport it to the first mdb, blowing away the original table first.

Jeremy

PS: PLEASE make a backup before doing anything like this.

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[Jaxson22]

You're a genius! Why didn't I think of that?
It didn't follow the table, so I just imported it and its ok now.
Thank you soooooo much!

jackie

 

[JeremyNYC]

Glad my post was helpful!

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.