Reserved error (-1517); there is no message for this error

[shank]

What the heck does this mean?
Reserved error (-1517); there is no message for this error

I'm running a simple append query and got this error. It's the same query
I've ran for 1 year+. I assumed that it was a quote or apostrophe that got
in the way within the data, but nothing. How do I troubleshoot something
like that?

thanks

 

[Joan Wild]

What the heck does this mean?
Reserved error (-1517); there is no message for this error

This error will occur if you change the design of a table, but don't follow
through with a compact. If your database is split, it is a good idea to
compact the backend after a design change, and also refresh the links in the
frontend and compact it.

 

[kassamjuma]

shank wrote:
> What the heck does this mean?
> Reserved error (-1517); there is no message for this error

This error will occur if you change the design of a table, but don't follow
through with a compact. If your database is split, it is a good idea to
compact the backend after a design change, and also refresh the links in the
frontend and compact it.

--
Joan Wild
Microsoft Access MVP

Hi Joan,

Of all the responsses I saw on the net, yours made the best sense. If you change the design of the backend, compact it, compact f/e and then re-link.

Thank you very muck

Kassam Juma