Update Query to Linked Table in Access

AJCButler

AJCButler

Joined
May 17, 2005
Messages
105
Reaction score
0
I have come across a problem that I have not come across in Access before.
I am trying to create an update query which updates a null field to 1 in a linked table.
I keep getting the message:

'Updating data in a linked table is not supported by this ISAM'.

How can I get around this problem?

Regards
AJ
 
Not sure what your asking mate. Link table in what?

I'm sure someone will know what you mean tho!

Summat to do with Excel is it?

Ahh read it again MS Access? DOH ;)



Bare with me i'll try get u some help asap
 
Last edited:
Try this from a good friend of mine....

Ok linked tables are, (I presume), external tables on another DB linked into the current access db. I can understand why it has problems but there is another way of doing this instead of linking the table you can ... hold on let me see

...................................


http://msdn.microsoft.com/library/chs/default.asp?url=/library/CHS/dntaloc/html/office10052000.asp

This article helps a little but you need more information on what he is linking too?

 
Thanks for your help.
I was trying to append from an Access table into an excel table, which I gave up on.
I have found a way around this though.
I have deleted the file and made the database create a new one.

This worked.

Cheers anyway!
 
Back
Top