Query works on dev db, gets a Run-time error '3073': Operation mustuse an updateable query on Pre-pr

[John]

Hello all,

I have an update query that works fine in my Development database that
I use to run ad hoc requests or tinker around with new stuff. The same
query in a database I have set up as 'pre-prod' that I eventually
convert to and accde and distribute to my users gets a "Run-time error
'3073': Operation must use an updateable query." error. It seems
pretty simple, here's the SQL:

UPDATE DISTINCTROW tbltXSReport INNER JOIN qryDomesticNon ON
tbltXSReport.CompanyNum = qryDomesticNon.CoNum SET tbltXSReport.Status
= [qryDomesticNon]![Status];

tbltXSReport is a local table in the users front end. It's a temp
table used for this process and cleared out at the end. qryDomesticNon
goes out to a SQL Server table to get a couple of fields. Here's the
SQL for it:

SELECT IIf([CPY_USOnlyAccount]=0,"Nondomestic","Domestic") AS Status,
dbo_uvw_application_L1_CompanyOrganizationContactsALL!CPY_CORPID &
dbo_uvw_application_L1_CompanyOrganizationContactsALL!CPY_COMPANY_ID
AS CoNum
FROM dbo_uvw_application_L1_CompanyOrganizationContactsALL
ORDER BY IIf([CPY_USOnlyAccount]=0,"Nondomestic","Domestic"),
dbo_uvw_application_L1_CompanyOrganizationContactsALL!CPY_CORPID &
dbo_uvw_application_L1_CompanyOrganizationContactsALL!CPY_COMPANY_ID;


Again, it works fine in one database and I get the 3073 in the other.
They are both in the same folder on a network drive and both use the
same tables. I deleted all of the object involved from the pre-prod
database and imported them back in from my dev database, same error. I
am able to manually go into tbltXSReport on the pre-prod db and update
it so I don't know why the query doesn't work.

Any ideas?

Thanks,

John

 

[Duane Hookom]

I would make sure the primary and foreign keys are all the same in dev and
prod environments.