Linked table ISAM problem

[Michael Plant]

Hello one and all.

I have a stored table in my database and the form I'm using is based on a
query that draws data from my stored table and a linked table. The linked
table is a *.txt file.

However, whenever I try to edit data I get the error message "Updating data
in a linked table is not supported by this ISAM." I can understand not being
able to edit the linked data, but the field I'm trying to update is drawn
from the stored table. All I have is a childish command in a module that
copies the content of one field (from the linked table) into the another
field (in my stored table). I'm somewhat confused because linked tables in a
*.csv can be updated and 4 hours of net searching has just left my head
spinning. Is it a problem with my installation?

I know I can achieve the same results by either importing the linked data
into a tempory table, editing my field then deleting again...or I can run an
update query based on all the scenario's I'll be coding into VBA, but a
simple me.duedate = me.stock_eta would be soooo much simpler and more
efficient.

Kind regards,
Michael Plant

[Michael Plant]

I've spent the weekend trying to find reference to this and I'm no clearer
than on Friday. I can edit spreadsheets, but no *.txt or *.csv files. This
means that any forms that have been built on queries based on or linked to
linked tables do not work. I have thought through how to work it without
linking data, but that means half the form would be built up of dlookup
fields which I understand would slow things down considerably.

Has anyone else had this error "Updating data in a linked table is not
supported by this ISAM." and who might be able to help me resolve it please.

Kind regards,
Michael Plant

"Michael Plant" <iu*****@hotmail.com> wrote in message
news:10****************@despina.uk.clara.net...

Hello one and all.

I have a stored table in my database and the form I'm using is based on a
query that draws data from my stored table and a linked table. The linked
table is a *.txt file.

However, whenever I try to edit data I get the error message "Updating data in a linked table is not supported by this ISAM." I can understand not being able to edit the linked data, but the field I'm trying to update is drawn
from the stored table. All I have is a childish command in a module that
copies the content of one field (from the linked table) into the another
field (in my stored table). I'm somewhat confused because linked tables in a *.csv can be updated and 4 hours of net searching has just left my head
spinning. Is it a problem with my installation?

I know I can achieve the same results by either importing the linked data
into a tempory table, editing my field then deleting again...or I can run an update query based on all the scenario's I'll be coding into VBA, but a
simple me.duedate = me.stock_eta would be soooo much simpler and more
efficient.

Kind regards,
Michael Plant

[Dimitri Furman]

On Jan 26 2004, 09:27 am, "Michael Plant" <iu*****@hotmail.com> wrote in
news:10****************@ersa.uk.clara.net:

I've spent the weekend trying to find reference to this and I'm no
clearer than on Friday. I can edit spreadsheets, but no *.txt or *.csv
files. This means that any forms that have been built on queries based
on or linked to linked tables do not work. I have thought through how
to work it without linking data, but that means half the form would be
built up of dlookup fields which I understand would slow things down
considerably.

Has anyone else had this error "Updating data in a linked table is not
supported by this ISAM." and who might be able to help me resolve it
please.

Unfortunately, this is the way Jet Text ISAM works - it effectively
provides read-only access to text delimited files. Any query that has a
linked text table in it will also have that limitation, even if you do not
attempt to modify the columns from the text table.

You may consider setting up a synchronization procedure that will keep a
mirror of the text file in a native Jet table, and query against that
table.

--
(remove a 9 to reply by email)

[Michael Plant]

Thanks Dimitri

I solved the problem by creating a temporary table from code which deletes
when the form closes again.

Kind regards,
Michael

"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...

On Jan 26 2004, 09:27 am, "Michael Plant" <iu*****@hotmail.com> wrote in
news:10****************@ersa.uk.clara.net:

I've spent the weekend trying to find reference to this and I'm no
clearer than on Friday. I can edit spreadsheets, but no *.txt or *.csv
files. This means that any forms that have been built on queries based
on or linked to linked tables do not work. I have thought through how
to work it without linking data, but that means half the form would be
built up of dlookup fields which I understand would slow things down
considerably.

Has anyone else had this error "Updating data in a linked table is not
supported by this ISAM." and who might be able to help me resolve it
please.

Unfortunately, this is the way Jet Text ISAM works - it effectively
provides read-only access to text delimited files. Any query that has a
linked text table in it will also have that limitation, even if you do not
attempt to modify the columns from the text table.

You may consider setting up a synchronization procedure that will keep a
mirror of the text file in a native Jet table, and query against that
table.

--
(remove a 9 to reply by email)