3011 - Transfertext

[Jim]

I have a form that exports a table with the following command:
docmd.transfertext asExportFixed, "tbl_el Export Specification",
"tbl_el", "C:\tbl_el.txt"

That works great on my test system. When I copy the database and send
it to my client, they get - 3011 can't the object find "tbl_el#txt".
(Yes #).

I've verified that tbl_el Export Specification exists. I create the
table in code. The only time I use the TXT extension is in the docmd.

Any ideas?

Jim

 

[John Nurick]

Hello Jim,

This (with the #) can happen if the export specification doesn't
actually match the structure of the query or table being exported.
Typically, there's a discrepancy in the field names. That sounds
unlikely in the situation you describe, but a couple of web searches
over the years haven't suggested anything else.

 

[Jim]

I checked each field name and length. They all match. Darn.