Update Query to Linked Table in Access

[AJCButler]

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

 

[TriplexDread]

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

 

[TriplexDread]

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?

 

[AJCButler]

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!

 

[TriplexDread]

Ok well least you got it sorted