Access 2003 conversion docmd.transfertext to linked table

[Tony L]

I have code that ran okay in Access 2000 that is not working when I convert
it to Access 2003. It seems like it should be pretty simple and
straightforward, but I'm not figuring it out. This is an *.adp file.

Here's how it read in Access 2000:

DoCmd.TransferText acImportDelim, , "dbo.tmpErod",
"C:\FTP\VegMan\erod.txt", False

This code captures a file and imports it into a temporary table in a linked
SQL Server 2000 database. In Access 2003, it throws an error message: "3078:
The Microsoft Jet Database engine cannot find the input table or query
'dbo_tmpErod'. Make sure it exists and that its name is spelled correctly."

I can read all the other tables from SQL Server, so I believe my
connectivity is not a problem. If I attempt to rename the filename, then it
creates a new file by that name (e.g. "dbo_tmpErod" or "tmpErod") and inserts
it into the Access file.

Any idea how to make this one work?

 

[i_takeuti]

I have code that ran okay in Access 2000 that is not working when I convert
it to Access 2003. It seems like it should be pretty simple and
straightforward, but I'm not figuring it out. This is an *.adp file.

Here's how it read in Access 2000:

DoCmd.TransferText acImportDelim, , "dbo.tmpErod",
"C:\FTP\VegMan\erod.txt", False

This code captures a file and imports it into a temporary table in a
linked
SQL Server 2000 database. In Access 2003, it throws an error message:
"3078:
The Microsoft Jet Database engine cannot find the input table or query
'dbo_tmpErod'. Make sure it exists and that its name is spelled
correctly."

I can read all the other tables from SQL Server, so I believe my
connectivity is not a problem. If I attempt to rename the filename, then
it
creates a new file by that name (e.g. "dbo_tmpErod" or "tmpErod") and
inserts
it into the Access file.

Any idea how to make this one work?