Table not yet been added to the Tabledefs collection?

[Jane]

I am using Access 2000.

When I step through the code below, it works without problem; when I run the
code it fails.

The error message tells me that it cannot find the input table 'Header';
however it is imported correctly.

I think that the table 'header' has not yet been added to the tabledefs
collection, but I don't know what to do about it.

Any help would be much appreciated

Jane
*****************************************
Dim db as DAO.database
dim recheader as recordset

set db = currentdb

DoCmd.TransferText acImportFixed, "HDHeader", "Header",
c":\abds\Import\filename", False

set recheader = db.openrecordset("Header")
**********************************************

 

[Jane]

Thanks for the thought, but I am afraid that did not fix the problem...