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

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.

Hi

Humour me a second here

try and use this instead....

DoCmd.RunCommand acCmdSave