Link text files problem running on AutoExec Macro

[netsmurph]

I have a database that uses linked tables and linked text files.

At startup I need to relink the tables to tables/files in the same directory as the application db.

The procedure runs fine if run the both are executed separately or together (in one macro), but if I put one or both into an autoexec macro, the relink text files procedure errors out, saying that it cannot find the specified path, while the relink tables is successful.

I cannot see why this should execute differently via the Autoexec macro and have exhasted all possibilites that i can think of.

Does anyone have any idea why this would be occuring or how to get around it?

Is there are way to run code at startup not using the autoexec macro?

Thanks if anyone can help out on this puzzling one.

Andrew