On Sat, 20 Mar 2010 20:34:01 -0700, HarkitsMark
wrote:


Interesting suggestion. Can you tell me what that DAO statement/code looks
like? Does this actually work or is it just an idea? Thanks

If you want an automated DAO approach to relinking tables, you're
welcome to use our free J Street Access Relinker on our J Street
Downloads page: http://ow.ly/M56Q

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com