Table not yet been added to the Tabledefs collection?

  • Thread starter Thread starter Jane
  • Start date Start date
J

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")
**********************************************
 
Back
Top