Append two linked tables.

[Beatrice]

Hi all,

I'm trying to append a linked table to another one.

Unfortunately I obtained the following pop-up error message:
"Operation must use an updatable query"
Where is my mistake???

Thanks in advance for your help.

Beatrice

[Rabbit]

Hi all,

I'm trying to append a linked table to another one.

Unfortunately I obtained the following pop-up error message:
"Operation must use an updatable query"
Where is my mistake???

Thanks in advance for your help.

Beatrice

You haven't given us anything with which to spot a mistake. You need to at least post the SQL code you're using.

The only thing I can say at this point is that your mistake is making an non-updateable query. And there are a few ways to make this mistake and dozens of variations on each of those.

[Beatrice]

You haven't given us anything with which to spot a mistake. You need to at least post the SQL code you're using.

The only thing I can say at this point is that your mistake is making an non-updateable query. And there are a few ways to make this mistake and dozens of variations on each of those.

Hello Rabbit,

many thanks for your reply.

Please find below the SQL instruction I used to perform the append (I tried in many different ways, with the same result)

INSERT INTO ASE_Data1 
(Plant, DeviceType, LotNo,Schedule,TestProg, ProgramVer,Platform,TestInDate,TestOutDate,InQty,GoodQty,Yield,Bin1,Bin2,Bin3,Bin4,Bin5,Bin6,Bin7,Bin8,Bin9)
SELECT [Utac_Q].Plant, [Utac_Q].DeviceType, [Utac_Q].LotNo,  [Utac_Q].Schedule, [Utac_Q].TestProgam, [Utac_Q].ProgramVer, [Utac_Q].Platform, [Utac_Q].TestInDate, [Utac_Q].TestOutDate,[Utac_Q].InQty, [Utac_Q].GoodQty, [Utac_Q].Yield, [Utac_Q].GoodQty, [Utac_Q].Bin2, [Utac_Q].Bin3, [Utac_Q].Bin4, [Utac_Q].Bin5, [Utac_Q].Bin6 , [Utac_Q].Bin7, [Utac_Q].Bin8, [Utac_Q].Bin9
FROM Utac_Q

Where UTAC_Q is the table i want to append to ASE_DATA.

I agree with you about the updatable query hypothesis, but I need a way to do it!

Thanks and Regards,
Beatrice

[Rabbit]

Did you copy and paste this?

You have spacing issues in GoodQty and Bin8.

[Beatrice]

Did you copy and paste this?

You have spacing issues in GoodQty and Bin8.

Yes, Rabbit,
is only a Copy&Paste problem...

[Rabbit]

Yes, Rabbit,
is only a Copy&Paste problem...

If it's copy and paste then you need to get rid of those spaces in your SQL code. As far as errors go, there's nothing wrong with your SQL syntactically that would throw a non updatable error. That is assuming both of those objects are really tables and not queries.

[Beatrice]

If it's copy and paste then you need to get rid of those spaces in your SQL code. As far as errors go, there's nothing wrong with your SQL syntactically that would throw a non updatable error. That is assuming both of those objects are really tables and not queries.

Hello Rabbit,

thanks for your help.

I'm trying to solve the problem using a different approach.

Regards,
Beatrice

[Beatrice]

Hello Rabbit,

unfortunately, the different approach fails!

Do you have any idea how to append/merge two different linked tables?

I cannot understand why a linked table should be un-updatable!

Thanks and Best regards,
Beatrice

[Rabbit]

There's no reason they shouldn't be updatabale. What/where are they linked to?

[Beatrice]

There's no reason they shouldn't be updatabale. What/where are they linked to?

Hello Rabbit,

sorry fot hte late reply, but I was very busy for other problems not related to my database.

Now Iwould like to use the few free time to finish it...
The problem is always the same: I receive data from two different sites in two different table, I link them in two different tables named ASE_Data1 and UTAC...
(they have different format... but contain the same data)
now in order to use all queries based on ASE_Data1, I want to append Utac data in ASE_Data1 table....
but I have always the same error message...Unupdataeble tables....

Why??

Thanks for your help!

Beatrice

[LyndaS]

Hi Beatrice,

Since it's April - I would hope that your problem was resolved by now.
If not, give this a try.

Both of the tables you are using should have a unique key. This error is typically created when you have one table does not.

If you are linking to SQL tables, be sure to choose a unique identifier and click on save password. If you are working with local tables, create a unique ID or assign one to an existing column.

Hope this is helpful.
Lynda