Error 3027 when importing text file

[tym]

Got a weird one here...

Up until recently (not exactly sure when) I've been absolutely fine importing text files into Access 97 with the import wizard, where the file extension is .log

Now, every time I do it, I get Error 3027 unable to update as database/object is read only.

if I change the filename to .txt it works, but if I leave it as .log I get that error.

What in the sweet name of Christmas is going on!?!?!?!?!?

[ajetrumpet]

anything could be going on, really. Anything from access corruption, to the obvious.

For instance, if the file is .log, then obviously a 3rd party application is creating it and streaming data to it. So for instance, if the "someone" that's creating the log file happened to break their application for debugging purposes after the log file was created by the code, and then just quit their app without thinking, the data stream is considered still open by windows. Hence, windows won't even let you delete the file until the stream is closed, either by the app or some other means.

That's what this issue sounds like.

[tym]

The log file is something I've created myself. It is downloaded from my ftpsite and imported into Access for processing. There's nothing keeping it open on my PC .

If I rename the original file to .txt, it will import. If I copy the original and rename *that* it will import. If if rename the copy back to .log it won't...

[ajetrumpet]

The log file is something I've created myself. It is downloaded from my ftpsite and imported into Access for processing. There's nothing keeping it open on my PC .

If I rename the original file to .txt, it will import. If I copy the original and rename *that* it will import. If if rename the copy back to .log it won't...

well then something must have changed, eh?

here are some ideas that may expand your knowledge:

*'read only' button checked when downloading from ftp?
*something change with the download client app?
*is the file 'read only' in the windows directory? (Alt+Enter on the file to find out)

The alt that I can see here, is to automate the re-naming of the file with vb. vb has an internal function called NAME() that will do this.

those are some ideas that may help ya. I'm out for now. That's all I have time for, in terms of helping here. good luck!

[tym]

The file is NOT read only.

If I change the extension to .txt it will load fine

if I change it back to .log it fails