I'm a VFP person, so this is a bit foreign to me:

I have a whole list of edit queries in Access that were built on local tables. The tables have since been moved to an external db file to aid in distribution, but the queries now give "table not found" errors when run.

The linked tables have identical names as the local tables had....this worked well when running SQL statements, but the Queries must be somehow hard-coded for location.


any ideas?