Problem linking to text file.

[PantoKing]

Hello,

I have a problem with having a text file as an attached table. The file is an export from another system which is produced with file extension .dp4, basically it is a comma delimited text file. Previously MS Access attached to this file as a linked table with no problems at all. Today however when we try to link to it we get the error message "Cannot Update. Database or Object is Read Only". I've checked the file and it isn't read only and is updatable via notepad. When I rename the file to .txt it will allow it to attach as a table.

I realise the easiest fix would be to rename it but there are several pieces of code that are depndant on it having the .dp4 file extension.

Any Ideas why this may have occurred.

Cheers,

Steve.

Make things as simple as possible — but no simpler.

 

[KenReay]

Hi

This is a "feature" added in Access2000 and subsequent versions. Error message is confusing. The problem is that the extension (.dp4) is not in the list of "valid" extentions (held in a registry entry). To fix, either rename the file so it has an extension of .txt or edit the registry entry to add .dp4 to the list of acceptable extensions

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK