Prev: Formating Formulas in Access
Next: Is It Possible to Control Access Warning Pop-Up Message Boxes?
From: Duane Hookom on 15 Apr 2010 11:32
I would make sure the primary and foreign keys are all the same in dev and
prod environments.

--
Duane Hookom
Microsoft Access MVP


"John" wrote:

> 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
> .
>
 | 
Pages: 1
Prev: Formating Formulas in Access
Next: Is It Possible to Control Access Warning Pop-Up Message Boxes?