Hi all

Did anyone find a solution to this problem ?



GS



> In the current setup [LAN controlled] I can add a record to a linked 

[.csv]

> table but can NOT edit any records.

> Error: "Updating data in a linked table is not supported by this ISAM.

> (Error 3616)".

> Please, what do I have to do to enable /install the required driver!?

> Thanks,

> Chris 

I found one article on the subject.  Go to Microsoft's knowledgebase 

http://support.microsoft.com/default.aspx?ln=EN-US&pr=kbinfo&

and look for article ID Q146220



It says that "The Text File ODBC driver does not support the SQL DELETE

or UPDATE statements" if you are using MDAC 2.5 or 2.6 and this is by

design.



In other words, you cannot use UPDATE or DELETE SQL statement to change

the .csv file.



John Ruff - The Eternal Optimist :-)





-----Original Message-----

From: Prakash GS [mailto:prakashg@m...] 

Sent: Friday, January 25, 2002 6:44 AM

To: Access

Subject: [access] Re: Edit a linked [.csv] table from Access97





Hi all

Did anyone find a solution to this problem ?



GS



> In the current setup [LAN controlled] I can add a record to a linked

[.csv]

> table but can NOT edit any records.

> Error: "Updating data in a linked table is not supported by this ISAM.



> (Error 3616)". Please, what do I have to do to enable /install the 

> required driver!? Thanks,

> Chris