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

  • Thread starter Thread starter Berny
  • Start date Start date
B

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!!!!!
 
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
 
Back
Top