Any help would be greatly appericated.
I am getting the error 3051 when I try to execute the transfer text action with the do command. The error reads: "The Microsoft Jet Database engine cannot open the file ". It is already opened exclusively by another user, or you need permission to view its data (error 3051)."
my transfer text command looks sorta like this in the on click event of a command button:
DoCmd.TransferText acImportFixed, "REPORT ORIGINAL READ", "MASTER TABLEB", MYPATH, False
**MYPATH IS A STRING VARIABLE THAT IS GIVEN A VALUE BY THE USER IN AN INPUT BOX
ANY IDEAS???
THANKS FOR THE HELP IN ADVANCE
JOHN
I am getting the error 3051 when I try to execute the transfer text action with the do command. The error reads: "The Microsoft Jet Database engine cannot open the file ". It is already opened exclusively by another user, or you need permission to view its data (error 3051)."
my transfer text command looks sorta like this in the on click event of a command button:
DoCmd.TransferText acImportFixed, "REPORT ORIGINAL READ", "MASTER TABLEB", MYPATH, False
**MYPATH IS A STRING VARIABLE THAT IS GIVEN A VALUE BY THE USER IN AN INPUT BOX
ANY IDEAS???
THANKS FOR THE HELP IN ADVANCE
JOHN
