Results 1 to 2 of 2
2002-12-19, 17:09 #1
- Join Date
- Sep 2002
- Thanked 0 Times in 0 Posts
update before append (Access 2000)
I have two tables,called orders and orders1.I am receiving the table orders1 from another
user and i am appending the table orders1 to the table orders.I have the following problem. If once i have
appended an order, say Number 13870, this number remains in the table orders. However if
the order 13870 is deleted in the table orders1, the table orders keeps on having the order.
Therefore i have to find a way to update the table before appending it.I have built the
Public Function FncUpdateOrders()
Dim strUpdateOrders As String
strUpdateOrders = " UPDATE orders INNER JOIN orders1 ON orders.orderID = orders1.orderID SET " & _
"orders.orderID = [orders1].[OrderID]"
However, i receive the following error:
cannnot update "orders.orderID;
field not updatable
Can somebody help me update my table in the
2002-12-19, 19:55 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- Thanked 32 Times in 32 Posts
Re: update before append (Access 2000)
<<However if the order 13870 is deleted in the table orders1, the table orders keeps on having the order.
Therefore i have to find a way to update the table before appending it>>
What do you wish to do here? Do you want to delete the record from orders?
The update query you have is trying to update orderid, but this is the join field???
Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>