DoCmd.RunCommand acCmdSaveRecord not working

[bhushan]

Hi there

I have to make the access project to use the sql server 2000 backend. I have a problem while executing the project the command

DoCmd.RunCommand acCmdSaveRecord

It gives me following error
Run-time error '2046'
The command or action 'SaveRecord' isn't available now.

Can any body plz help me this regards

 

[llkhoutx]

That could mean a non-updatable recordset is involved or possibly an non-autonumber index has not been created.

It's hard to tell from your posting.

 

[SQL_Hell]

Hi

Humour me a second here

try and use this instead....

DoCmd.RunCommand acCmdSave