new record button no longer works 1

[scroce]

I've just moved my tables to SQL Server 2000

I have a new record button on a form that used to work just fine.

now when I click it, error 2105 saying "you can't go to that record" end-debug-help pops up. When I click help, all I get is a blank screen.

the code is simply

DoCmd.GoToRecord , , acNewRec


looks like I do have select, insert, update, delete permissions to the underlying table.

why doesn't this work any more, and how do I fix it????






I am a nobody, and nobody is perfect; therefore, I am perfect.

 

[jgoodman00]

Once you have a primary key in place, you can delete rows from the table in Access, as you would an MDB.

There seems to be some kind of quirk whereby you cannot modify records in a SQL Server table directly from Access unless it has a PK.

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[jgoodman00]

In SQL EM (Enterprise Manager), expand the database, tables, & then select 'Design Table' for the table in question. The design window is similar to Access...

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[scroce]

ok that helps point me in the right direction.

the problem now is that it won't let me set the PK, b/c somehow there is a renegade record in the table that is showing a null in that field. (I don't know how that got there)

So how do I delete that record? in access you can just click on the row and press delete and the entire thing is gone. This doesn't let me seem to do that.

I am a nobody, and nobody is perfect; therefore, I am perfect.