Error When Running Query

[Manuel]

I have a query which gives a error message everytime I run
it. The message it as follows:

"The text file specification 'FEE Link Specification' does
not exist. You can't import, export, or link using the
specifiction."

What does this mean? I believe it has to do with a
formula I've writen in the query which uses a field from a
linked table - but the table does exisit, and I do use
other fields from this same linked table in other formulas
(in that same query) with no problem.

Any help would be MUCH appreciated.

Thanks,

Manuel
..

 

[[MVP] S. Clark]

Post the SQL.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[DD]

After much hunting for this error in similar circumstances I came
across this post that worked for me.
I am connecting textfiles as tables via code, and specify the import
spec there. At the beginning of my code I add these two lines:
On Error Resume Next
Docmd.TransferText
....and suddenly all table connections work.
For you, try adding these two lines into your AutoExec and see if that
does it.