By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,668 Members | 1,442 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,668 IT Pros & Developers. It's quick & easy.

Linked table ISAM problem

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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)
Nov 12 '05 #3

P: n/a
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)

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.