Update Query in adp not the same as mdb?????

[Berny]

Access allows me to have two tables linked in an Update Query and update a
field in the table.

I use this to compare records in two tables to identify and mark duplicate
records for deletion in one of the tables before I merge (append) the
tables.

When I use the adp it doesn't allow me to have more than one table in the
query when I select Update Query.

Am I doing something Wrong?????

Please help or point me in the right direction.

Any help would be greatly appreciated!!!!!

 

[BJ Freeman]

By access are you using the ADP or Access MDB?
if you are using the ADP then you can create views with as many tables as
you wish.
then use a storedproceedure to do the update

Alter PROCEDURE SP_UpdtOrderInvoices
@invoice as varchar(50),
@OrderNumber as varchar(50),
@SKU varchar(50)
AS
SET NOCOUNT ON
UPDATE VwUpdateOrdersInvoices
SET
SupplierInvoice = @Invoice,
status=4,
[Order Details Updated]=getdate()
where SKU = @SKU
and OrderNumbers= @OrderNumber

RETURN 0

or
Alter Procedure SP_UpdtOrdersRRI
As
/* set nocount on */
Update dbo.VwOrdersRRI
SET
StatusID= 3
,[Order Details Updated] = getdate()
-- , ShipDate = getdate()

Return