Error When Running Query

  • Thread starter Thread starter Manuel
  • Start date Start date
M

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
..
 
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.
 
Back
Top