Linked table ISAM problem

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

re: Linked table ISAM problem

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" <iumiash@hotmail.com> wrote in message
news:1074894336.28650.0@despina.uk.clara.net...[color=blue]
> 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[/color]
data[color=blue]
> in a linked table is not supported by this ISAM." I can understand not[/color]
being[color=blue]
> 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[/color]
a[color=blue]
> *.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[/color]
an[color=blue]
> 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
>
>[/color]

re: Linked table ISAM problem

On Jan 26 2004, 09:27 am, "Michael Plant" <iumiash@hotmail.com> wrote in
news:1075127281.15956.0@ersa.uk.clara.net:
[color=blue]
> 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.
>[/color]

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)

re: Linked table ISAM problem

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" <dfurman@cloud99.net> wrote in message
news:Xns947CD82D68CBFdfurmancloud99@127.0.0.1...[color=blue]
> On Jan 26 2004, 09:27 am, "Michael Plant" <iumiash@hotmail.com> wrote in
> news:1075127281.15956.0@ersa.uk.clara.net:
>[color=green]
> > 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.
> >[/color]
>
> 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)[/color]