error after compacting back-end

[Robert Szaszvari]

After compacting a 100 MB back-end .mdb file without any problem, a user
received this error when trying to add a new record through a form:

Reserved error (-1517); no message for this error.

The field in question has a default value of zero, and that is showing when
opening the form. As soon as the user tabs into the field, this message
pops-up.

Needless to say, no article on MS KB comes up with this error number.

Software: Access 2000 on Windows 2000 Pro, all patches and service packs are
current on both the OS and Office 2000.

Thanks in advance for any suggestions.

Robert Szaszvari

 

[Tony Toews]

After compacting a 100 MB back-end .mdb file without any problem, a user
received this error when trying to add a new record through a form:

Reserved error (-1517); no message for this error.

Relink the tables in the FE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Robert Szaszvari]

Relink the tables in the FE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Re-linked tables without errors. Still received "Reserved error (-1517);..."
message.


Robert

 

[Tony Toews]

Re-linked tables without errors. Still received "Reserved error (-1517);..."
message.

I'm curious. How did you relink the tables? Using the Linked Table
Manager Add-in?

Try compacting the FE. If nothing else works then delete the table
link and recreate the link.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Robert Szaszvari]

I'm curious. How did you relink the tables? Using the Linked Table
Manager Add-in?

Try compacting the FE. If nothing else works then delete the table
link and recreate the link.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I did use the LTM add-in in the first place.
Followed your suggestions [compacting the FE] with no success. Finally,
re-creating the table links did the job.

Thank you very much for your help.
Robert