I have been looking for a reason behind a pesky error 3051 I am getting with an Access 97 MDB file. In all of the research I have done so far, the error message "The Microsoft Jet database engine cannot open the file " has either been followed with "(Unknown)" or with an MDB file name.

I ma getting the error when my code is trying to import a text file into a table using the DoCmd.TransferText command and a predefined specification.

What I have found so far is that this error is related to permissions (at least when it is associated with an MDB file name). Is the same true for TXT files?

Tim Smith
Advance Magazine Group
Wilton, CT