Text file spec does not exist?

[Charles P. \(Pat\) Upshaw]

I have an Access97 database. There is a form which has a subform which uses
a query based upon two linked tabels as the data source. When I open the
form I get the error message:

The text file specification "Natural Gas Master Link specification" does not
exist. You can;t import, export or link using the specification."
I then relink the table (overwriting the already linked table), using the
saved specification which the database says doesn't exist. So far, Ive had
to relink about 100 times, every time I open the form.

Does anyone have any ideas?

Thanks,
Charles P. (Pat) Upshaw

 

[Joan Wild]

It sounds as though the specification referenced in the code for the form is
not the correct name. Are you certain that the name is exactly the same?
(double check and look for missing/extra spaces)

 

[Charles P. \(Pat\) Upshaw]

Dear Joan:

I'm able to save the spec and through the "advanced" button, retreive it and
use it over and over. It's just when the database is first opened and the
form opened that I the db can't find it.

Thanks,
Pat Upshaw

 

[Joan Wild]

Check the code behind the form - there is code that is referencing this
specification. The reference in the code may be mis-spelled.

 

[Charles P. \(Pat\) Upshaw]

Dear Joan:

There is no code that references the linked table or the specification.

Remember that if I relink the table (using the same saved specification),
the form will open without error. I will open without error until I close
the database and then reopen it and try to open the form.

I haven't spelled the asc file name or the specification anywhere. I only
point and click in the linking process.

Please help. This is most annoying.

Pat Upshaw

 

[Joan Wild]

Dear Joan:

There is no code that references the linked table or the specification.

But there must be, since you are getting an error message that refers to it.
Have you also checked the subform's code?

Remember that if I relink the table (using the same saved specification),

I don't understand this as linking never involves a specification.