Linking text file to Access database

[alpder]

I am running NT 4.0 sp6a. I use Client Access Express to connect to AS/400. I had to reformat my hard drive due to "Blue Screen" problems and reinstall everything. Most things are working except I cannot link a text file from my local C: drive. The message I get is "Link text file. Cannot update. Database or object is read only". The database and object are NOT read only. I have admin rights to everything. ODBC connections to AS400 databases are fine.

Today I installed MDAC2.6SDK and MS Jet 4.0 SP3 and I still get the errors. I have exhausted all my ideas and would be very grateful for any assistance.

 

[danvlas]

Just a thought...if you reinstalled from CD, the read-only attribute could be the file attribute. Select the file in Explorer, right click it, choose Properties and see if the Read-only attribute is checked. If yes, uncheck it and that's all...

Good luck,

Dan
Daniel Vlas
Systems Consultant

 

[KenReay]

Hi

Have not come across this with linked text files, but I have come across it when importing text files, are you by chance using Access2000 or AccessXP?

If yes, does your txt file have an extension of .txt?

If no, try renaming it to have an extension of .txt and see if it works.

The problem I have come across when importing txt files, is that Microsoft have now introduced a new 'feature' whereby the extension of the text file must be hild in a registry entry of valid extensions, otherwise you get this completely misleading error about the database being read only.

Maybe the same applies to linking text files?

Let me know how you get on, please

Regards

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

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

UK

 

[alpder]

Hi Ken,

You were right. My text file did not have .txt extension. I renamed it and it works fine.

Thanks a lot.