link a table using an .ADP access application

[ToniS]

I am using Access 2003 and have created an .adp, the back end is SQL Server,
I would like the ability to link to a text table located on the network. I
get the following error when I try to do this. "You cannot link to tables in
file 'filename.txt' because your Access project is connect to an SQL Server
database on a remote computer. ......." Any ideas on what I would need to do
or if this is even possible.

Thanks
TSharp.

 

[Sylvain Lafontaine]

Answered in the newsgroup m.p.a.adp.sqlserver.