How different than Access 2002?

[ericchajmovic]

Hello,

I just upsized a database created in Access 2002 to SQL Server 2000. When I press on the Next key on one of my forms with the code "DoCmd.GoToRecord , , acNext" and try and enter a new record, I get the message that the record is not updatable. It was in Access. What do I have to fix to get this working?

Thanks,

Eric Chajmovic

 

[MAK9974]

Access when linked to SQL server the rows wont be updateable.
u need to have index on all tables or create constraint in Access to linked tables

KB

http://support.microsoft.com/default.aspx?scid=KB;en-us;q208842

 

[SQLSister]

More importantly, you must have a unique field of some kind in the table, either a primary key, a unique constraint, an Identity field or a GUID.

 

[RiverGuy]

Actually, you must have a primary key. Not even an identity will let you update whilst using an Access Project.

 

[tlbroadbent]

You don't necessarily need a primary key though it is good practice to define primary keys on tables. You do need a unique column. That can be a primary key, timestamp column, uniqueidentifier column, or any other column with a unique constraint on it. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[RiverGuy]

Terry,

What I was saying is that an Access Project -- Not neccesarilly an Access .mdb with linked tables has problems w/o a primary key. I've seen this in .adp files.