A colleague recently converted an Access 97 mdb to Access 2000.
A process that deletes tables and recreates them while im****ting data
fails
to work. I believe I've resolved the issue down to this statement:
DoCmd.TransferText acIm****tFixed, "Im****t_HED", "TI_HED",
Concat_Dir_File(Me![Directory_Location], Me![Collar_ID]) & ".HED", False
Concat_Dir_File is a local sub that creates the file location and name.
That
works just fine.
Any ideas on why this would work in '97 and not 2000?
What is the meaning of the specification? Would it be in a file, or is it
set internally in Access?