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

R

Randy Wayne

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.
 
A

Allen Browne

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?
 
R

Randy Wayne

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...
 
A

Allen Browne

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.)
 
Top