PC Review


Reply
Thread Tools Rate Thread

Update Query to Linked Table in Access

 
 
Senior Member
AJCButler's Avatar
Join Date: May 2005
Posts: 100
 
      16th Sep 2007
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
 
Reply With Quote
 
 
 
 
Senior Member
TriplexDread's Avatar
Join Date: Jan 2003
Location: Where ever I want to be
Posts: 6,420
 
      17th Sep 2007
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 by TriplexDread; 17th Sep 2007 at 12:39 PM..
 
Reply With Quote
 
 
 
 
Senior Member
TriplexDread's Avatar
Join Date: Jan 2003
Location: Where ever I want to be
Posts: 6,420
 
      17th Sep 2007
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?


 
 
Reply With Quote
 
Senior Member
AJCButler's Avatar
Join Date: May 2005
Posts: 100
 
      20th Sep 2007
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!
 
Reply With Quote
 
Senior Member
TriplexDread's Avatar
Join Date: Jan 2003
Location: Where ever I want to be
Posts: 6,420
 
      23rd Sep 2007
Ok well least you got it sorted

 
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 - Copy linked table to a local table or have linked tableas read-only Stuart Microsoft Access 0 26th May 2012 10:28 PM
ACCESS table linked to EXCEL spreadsheet. How to know which table is linked? Art Microsoft Access 3 2nd Apr 2007 12:51 PM
ACCESS table linked to EXCEL spreadsheet. How to know which table is linked? Art Microsoft Excel Discussion 3 1st Apr 2007 10:14 PM
Help updating table from linked table(linked table is a csv) Thierry Microsoft Access Queries 2 29th Jun 2004 02:21 PM
UPDATE a linked access table with value from a ODBC linked SQL table JB Microsoft Access 0 18th Nov 2003 10:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:23 PM.