"Cannot update. Database or object is read-only" on import.

[DaveJHPT]

I'm sure I've missed something obvious but...

I'm getting the above error when I try to import from a text file and can't work out why; I get the same error using TransferText in code.

However, if I open the file, parse the data and put the data onto the table one record at a time (in code), it works fine (but slowly!)

The import file is a straightforward tab-delimited text file.

Can anybody help please?

Dave

 

[DaveJHPT]

...

I've checked everything I can think of - I have full access rights to the directory it's in etc. I also get the same problem if I try to link to the table rather than importing it.

I've looked for previous posts on this and can't find anything.

Anybody?

Dave

 

[Ron_dK]

Dave,

I found this with MSoft :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;304146

Hope this helps.

 

[DaveJHPT]

Sorted!

It just didn't like the extension ".tsv". Changed it to ".txt" and voilà!

Pretty unhelpful error message though...

Thanks anyway.

Dave

 

[Ron_dK]

How did you get that tsv extension.
As you probably recognized , Access only eats : csv or txt , tab or asc as text files.