link a table using an .ADP access application



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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question