can't update record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have MS Access 2002 FE with SQL server 2k BE and production and development DBs. I have a complex query that populates a form. The query is updateable in the production DB and not in the development DB. The query definitions are identicle. I've checked the individual tables and they are all updateable on the dev DB. Any suggestions as to what else I can check?
Thanks so much for any help. I've been searching for the problem all week.
 
My first thought is that you have a table in the development DB that has a
PK missing. When you want a complex query that contains references to more
than one table to be updateable, you normally need to ensure that the PKs
are properly defined.

HTH
Dale

smk23 said:
I have MS Access 2002 FE with SQL server 2k BE and production and
Click to expand...
development DBs. I have a complex query that populates a form. The query is
updateable in the production DB and not in the development DB. The query
definitions are identicle. I've checked the individual tables and they are
all updateable on the dev DB. Any suggestions as to what else I can check?
 
Thanks, Dale. After many hours of looking, I finally found a stored procedure with a reference to a column that has been deleted.
Thanks so much for your response!
 
Back
Top