A user was recently upgraded to Access 2000. Now when I try to run the following transfer text in vba I get an error, but only if the file I’m trying to import has a .dat extension. If I rename the file to .txt, it works fine. The statement in the vba is:
DoCmd.TransferText acImportFixed, “Modified Import Specs”, “Import”, filename
Before we converted the database (Access 97) we always used .dat files as the “filename”. That’s because they come from a scanner, and the extension it creates it as is .dat. Never had any problem. I just don’t understand why the extension type would make a difference here because I’m passing the name of the file explicitly.
The only thing I can find on knowledge base concerning this error (‘3027’ – Cannot update. Database or object is read-only) makes reference to ODBC connections and recordsets. I don’t see how that would apply here.
I’m stumped. Any suggestions?
Thanks.
