Microsoft JET, Access, frustration, and tears...

[LashStoat]

Dear BlueErica,

Before I even read Pirate Bill's post, I was going to suggest that the problem will definitely have been caused by changing the file locations during migration. The Linked Table Manager on the Tools Menu is the way to repair the file associations, but I think you said you still had trouble?

If so, is it possible that different versions (ie: restored from backups) have been mixed around, thus breaking the integrity of the system? Perhaps the file dates could help determine this. Are you able to run a Repair on the database(s)?

If you really, really get stuck, could you get the IT people to create a drive and folder structure that is identical to the original (ie: same drive letter and folder heirarchy), which will give you a stable starting point.

I hope this helps,

Love and hugs,

The Stoat XXX.