TransferText export fails

[Morten Snedker]

It's quite weird:

DoCmd.TransferText acExportDelim, , "tblFejlKode", sPath &
"tblFejlKode.txt", False

exports the content of a table to file. It works well run at home, it
works well run at work, but fails when running at customers setup:

....can't find the object 'tblFejlKode'.

Asking the customer to navigate to the database window choosing
tables, the table is in fact there. Asking to doubleclick and open
table, it opens and shows the records.

I'm running adp againts SQL-server 2000. I'm running a copy af the
database from the customer, so we have the exact same data.

The only thing I can think of, is that the code has tblFejlKode while
the actual table has tblFejlkode (the capital K) and that they're
running on Citrix. But that couldn't possible be it...

Any clues...? it's a long drive.... :-(


Regards /Snedker

 

[Ken Snell \(MVP\)]

I haven't worked with SQL Server, but from other posts I've noted that the
name of linked tables in such setups actually begin with dbo_ then the table
name.

Try running the code using dbo_tblFejlKode as the table name.

 

[Guest]

Did you update sPath when you moved it to the 'work' computer?? may be
trying to write to a directory that existed on your home PC but not at work..