G
G
I am running a simple update query in ACCESS 97.
I have linked to a table on the server, and would like it
to update a price field in my table in the database on my
computer. I keep getting the error message "Operation must
use an updatable query. (Error 3073)". I never had these
problems with later versions of ACCESS. Any help is
greatly appreciated.
Below is the code:
UPDATE tbl_client_assets INNER JOIN dbo_pim_asset_alloc ON
tbl_client_assets.asset_name =
dbo_pim_asset_alloc.asset_name_1 SET
tbl_client_assets.market_value = [dbo_pim_asset_alloc]!
[prim_price]
WHERE (((tbl_client_assets.client_id)=[Forms]!
[frmBuildStatementOfLiquidAssets2]![Combo33]));
G
I have linked to a table on the server, and would like it
to update a price field in my table in the database on my
computer. I keep getting the error message "Operation must
use an updatable query. (Error 3073)". I never had these
problems with later versions of ACCESS. Any help is
greatly appreciated.
Below is the code:
UPDATE tbl_client_assets INNER JOIN dbo_pim_asset_alloc ON
tbl_client_assets.asset_name =
dbo_pim_asset_alloc.asset_name_1 SET
tbl_client_assets.market_value = [dbo_pim_asset_alloc]!
[prim_price]
WHERE (((tbl_client_assets.client_id)=[Forms]!
[frmBuildStatementOfLiquidAssets2]![Combo33]));
G