Reserved Error (err.Number 3045) with DoCmd.TransferText

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any suggestions on why I would receive err.Description "Reserved Error"
(err.Number 3045) while using the DoCmd.TransferText?

The csv file to be imported is on the client PC, but was copied from a server.
The client PC has full control over the folder on the server.
The client has full control over the folder where the .mdf and ldf are
located.
Problem persists even after moving the csv file from the server to the
client PC

It does not happen on my development machine.
 
As the error message indicates, the file is already in use.

Perhaps some software has it open?
Or perhaps you used Open without a Close?
 
Allen:

I will check for something that has the csv file open, but I cannot think of
anything that would.

To be clear of the process:

A server creates a csv file through Windows Scheduler each night and places
the file in a shared folder.

The file is overwritten each night - it is always a new file.

The client "grabs" the csv and imports it with the DoCmd.TransferText on a
form.

To be clear, it happens only on the client.

Thanks for your input


Randy


Allen Browne said:
As the error message indicates, the file is already in use.

Perhaps some software has it open?
Or perhaps you used Open without a Close?
Click to expand...
 
Okay, I'll explain the reason for the suggestion.

In Access, press Ctrl+G to open the immediate window.

Enter:
? AccessError(3045)

Access responds with:
Could not use '|'; file already in use.
(The pipe is a place holder for the argument.)
 
Back
Top