DoCmd.RunCommand acCmdSaveRecord not working (1 Viewer)

B

bhushan

Guest

• Aug 21, 2006

• #1

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

 

L

llkhoutx

Registered User.

Local time

Today, 06:25

Joined

Feb 26, 2001

Messages

4,018

• Sep 6, 2006

• #2

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

SQL Server DBA

Local time

Today, 12:25

Joined

Dec 4, 2003

Messages

1,360

• Sep 7, 2006

• #3

Hi

Humour me a second here

try and use this instead....

DoCmd.RunCommand acCmdSave