3011: could not find object 'TECCBW#TXT'

[Meg]

The codes were working great in XP until an error message
appeared as 3011: The Microsoft Jet database engine could
not find the object 'fileName#txt'. Why is the period
being replaced by the pound (#) sign? I do not understand
why XP is giving so much problems in Access.

Help!!!!
Thanks.

Meg

 

[Ken Snell]

You'll need to tell us more about what you're doing when this error
occurs......let's see, you're running a union query that is the basis of a a
TransferText export to a file on another server......or is it something
else? < g >

 

[Meg]

I am using the acExportDelim to export a table into a
delimited txt file format.

Here it's the codes:

Private Sub cbxTEC_DblClick(Cancel As Integer)
On Error GoTo Error_cbxTEC_DblClick

stFL = Me!txtFLoc 'File Location
stQDA = "qdelACH" 'Delete Query for ACH
stQDB = "qdelWires" 'Delete Query for Wires

With Me.lblES
.Visible = True
.Caption = "TEC Export Status"
End With

With Me.ocxProgBar
.Visible = True
.Value = 20
End With

Me.Repaint

DoCmd.SetWarnings False
DoCmd.Hourglass True
DoCmd.OpenQuery stQDA, acViewNormal, acEdit
Me.ocxProgBar.Value = 30
DoCmd.OpenQuery "qryaExportTECACH", acNormal, acEdit
Me.ocxProgBar.Value = 40
DoCmd.TransferText
acExportDelim, "TECExport", "tblACHExport", stFL
& "TECACH.TXT", False, ""
Me.ocxProgBar.Value = 50
' Change the value of all TEC ACH items to Exported Yes
DoCmd.OpenQuery "qryuTECACHExported", acNormal,
acReadOnly
Me.ocxProgBar.Value = 60
DoCmd.OpenQuery stQDB, acViewNormal, acEdit
Me.ocxProgBar.Value = 70
DoCmd.OpenQuery "qryaExportTECBatchWire", acNormal,
acEdit
Me.ocxProgBar.Value = 80
DoCmd.TransferText
acExportDelim, "TECExport", "tblBWExport", stFL
& "TECBW.TXT", False, ""
Me.ocxProgBar.Value = 90
' Change the value of all TEC Batch Wire items to
Exported Yes
DoCmd.OpenQuery "qryuTECBatchWireExported", acNormal,
acReadOnly
Me.ocxProgBar.Value = 100
Forms!fmnuExportsSwitchboard!cbxTEC = 0

Exit_cbxTEC_DblClick:
With Me.lblES
.Caption = "Export Status"
.Visible = False
End With

Me.ocxProgBar.Visible = False

DoCmd.SetWarnings True
DoCmd.Hourglass False
Exit Sub

Error_cbxTEC_DblClick:
MsgBox Err.Number & ": " & Err.Description
Resume Exit_cbxTEC_DblClick

End Sub

 

[Ken Snell]

Is there a \ character at the end of the text string that is stored in stFL
variable? If not, you need to concatenate one into the filename argument in
the TransferText command:

DoCmd.TransferText acExportDelim, "TECExport", "tblACHExport", stFL & "\" &
"TECACH.TXT", False, ""

If that isn't the problem, then post back.