Macro Issue - Cannot Update

[Moxioron]

Hello all.

Ugh. A colleague told me that I should use the Macro function to import text files. I have always used VBA via the Modules to do it.

So anyway, I am using TransferText and I keep on getting a 'Cannot Update. Database or Object is read-only'.

For the file name I am using: \TKT01\RETURNS\CTO\KS0028 File Import\KS0028.MBK

I thought it was the .MBK extension, so I removed it, but still am getting the same message. I don't get this message using VBA/Modules.

Any thoughts? Thank you.

 

[Norie]

Use VBA?

If you get an error there then you might get a better idea of what the problem is.

 

[Moxioron]

Sorry. I meant when I use VBA to import the file I don't get any permission violation errors. It imports fine.

 

[Norie]

Well use VBA if it works.

I really don't see why you would want to use a macro, especially if it might not work.

Perhaps there are some hidden advantages I've never heard about.

 

[Joe4]

What happens if you change your file extension to a valid text file extension, like TXT?

 

[boblarson]

For the file name I am using: \TKT01\RETURNS\CTO\KS0028 File Import\KS0028.MBK

If that indeed is the file path you are passing it, then it should fail as that is not a valid path. It needs either a drive letter or the FULL UNC path. Any path that starts out with a single backslach is not a valid path.

 

[Joe4]

Good catch Bob. Don't know how I overlooked that...
I guess I was focusing too much on the file name and didn't check out the complete path.

 

[Moxioron]

That's not it. I didn't copy the entire path. Sorry about that.

K:\TKT01\RETURNS\CTO\KS0028 File Import\KS0028.MBK

 

[Norie]

I'm afraid I don't think that's the UNC path that Bob was referrring to.

 

[Joe4]

Does changing the file extension to TXT work?