Export error

[jxm28788]

I just tried an export of the catalog so I could make some changes, but it came up with this error :

There was a problem with the database. Operation: Opening the [price schedules] table sorted by [nID]. The microsoft jet database engine cannot find the input table or query 'Price Schedules'. Make sure it exists and that it's name is spelt correctly.

I did a compact/repair and tried again and it worked... but I'm a bit worried that it may have got corrupted and the repair had just deleted the corrupted stuff.

Unfortuntely, my DB is so huge and complicated it would be very difficult to spot if anything was wrong... So does anyone know what the above message means and do you think all is ok... or not?

ps. checked the access DB and the price schedules table does exist...

[Duncan Rounding]

If the compact/repair was successful then you should be ok. It's good to regularly compact the database.

[pinbrook]

normally compact and repair is fine.

I sometimes repair in access too

[jxm28788]

I had compacted it already this morning, before I did a sitesnapshot, guess access is just a bit flakey...