Reserved Error -1517

[Rick West]

My FrontEnd/BackEnd application has been working for 3 years, however, today it became stubborn. A FE query appends records to a BE table - simple enough - except today I am getting this error and the query will not append the records.

Why?

I don't know. I tried re-linking the tables, rebuilting the queries - still get the error. Size of the BE db (data side) is only .3G.

Any and all clues would be appreciated.

[Rainlover]

Sorry not enough information.

Retrace what you have done recently.

Maybe restore a Back up.

[Rick West]

I got it working by compacting and repairing the back end database, but why that worked is still a mystery to me since it was only .3G in size.

[Rainlover]

300 mb is quite large in access land.

A compact and repair should be a regular operation.

Back up first. Just in case.

[Rick West]

Explain your thoughts please because everything I read about Access says it can grow to 2G. What am I missing?

[Rainlover]

You are correct, 2G is the Max. But 300 M is still quite large.

I am merely suggesting that a Compact and Repair should be part of your regular activities.

But always back up before a Compact and Repair.