"this recordset is not updatable" problem in Access 2003

[Tomasz J]

"this recordset is not updatable" problem in Access 2003

Hello Developers,

I have an ADP file. It has been created in access 2000 where everything
works fine.

When this file is opened in Access2003 (without prior conversion) one of
forms becomes read-only - an attempt to update recordset produces "this
recordset is not updatable" message.

Data source is a simple view "select * from table where... ", table has a
unique index.
What can be wrong?

Like I said, when this ADP file is opened in Access 2000 everything works
fine.
Any ideas?

Thomas J

 

[S.Clark]

I think we had this problem, but thought it was an issue to do with the
change from SQL Server 2000 to 2005.

Go to the Recordsource itself and try to update a record in the grid. Does
it work there but not the form?

I don't have A2k installed, so I can't determine if there are any different
properties between the two... and I definately don't remember OTTOMH.

 

[Tomasz J]

Here is what I found in the meantime: if I change record source to the same
select statement I have in the view it works OK. I have no clue why. I have
even tried adding "with VIEW_METADATA" option - no difference.
Again, in Access 2k it works fine. I will try what you suggested.
TJ

 

[Tomasz J]

I think I identified the problem.

If Form.RecordSource is a SQL Server view then in Access 2003 some form
recordset properties have a different values compared to Access 2000:
"Unique Rows" = false
"Reshape Name" = ""

while in Access 2000:
"Unique Rows" = true
"Reshape Name" = "DSRowset1"

Interesting that in both cases recordset support the same functionality:
adAddNew
adApproxPosition
adBookmark
adDelete
adFind
adHoldRecords
adMovePrevious
adNotify
adResync
adUpdate
adUpdateBatch

Again, I am talking about the same ADP file with the same connection string
opened in Access 200 and Access 2003.

Any ideas?

Thomas J