By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Reserved Error 1601

P: n/a
I am working in MS Access 97, on a database which ahs been established
with no errors for a year. I have a dodgy field which has imported
into my database, I have no idea how.

A string of text, around 100 chars long has imported into a field
which is set at 12 chars.

This field is a primary key, and it has corrupted resulting in me
being unable to delete the data in that specific field and replace it
with the correct value. Neither am I able to delete the record, this
results in the reserved error 1601 message.

Does anyone have a solution to this as we are unable to work this
case.

Thanks
Katie

Aug 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can make a copy of the table's structure, and import all the other
records (being careful not to refer to the bad one.) Then replace the table
with this new one.

Details in the 3rd symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html#RowsShowDeleted

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Katie" <ka********@northernrock.co.ukwrote in message
news:11**********************@50g2000hsm.googlegro ups.com...
>I am working in MS Access 97, on a database which ahs been established
with no errors for a year. I have a dodgy field which has imported
into my database, I have no idea how.

A string of text, around 100 chars long has imported into a field
which is set at 12 chars.

This field is a primary key, and it has corrupted resulting in me
being unable to delete the data in that specific field and replace it
with the correct value. Neither am I able to delete the record, this
results in the reserved error 1601 message.

Does anyone have a solution to this as we are unable to work this
case.

Thanks
Katie
Aug 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.