Reserved error -1587, There is no message for this error

[Guest]

I compacted an mdb that serves as the server backend for an mde app.

Now several of my append queries fail with the above listed error..

I cannot find anything in the KB and/or help files that explain what's going
on.

When I revert to the "pre-compacted" copy I made before the Compact &
repair, everything works as espected..

A: What's causing this?
B: How do I fix the queries (tables) to allow me to use the compacted .mdb

'Preciate your help

 

[Guest]

OOPS tht's error -1517 not -1587

 

[Joan Wild]

OOPS tht's error -1517 not -1587

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.

I think it's that latter step that's fouling things up for you - refresh the
links and compact the frontend.

 

[Guest]

Thanx Worked like a charm

Who'd a Thunk?

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.

I think it's that latter step that's fouling things up for you - refresh the
links and compact the frontend.

 

[Guest]

I compacted an mdb that serves as the server backend for an mde app.

Now several of my append queries fail with the above listed error..

I cannot find anything in the KB and/or help files that explain what's going
on.

When I revert to the "pre-compacted" copy I made before the Compact &
repair, everything works as espected..

A: What's causing this?
B: How do I fix the queries (tables) to allow me to use the compacted .mdb

'Preciate your help