Write Conflict error.

[AccessBeetle]

I have a simple form based on a table which has several controls and subforms.
When I open the form and try to edit things it gives me this trritating error saying "Write Conflict". It has three options saying Save Record, Copy to Clipboard and Drop Changes. I want to overwrite but "Save Record" button is disabled. I forcefully have to select "drop changes."
Please let me know what is wrong here?
Thanks
I already tried this solution, but did not work
1. Form's RecordLocks property set to Edited Record
2. Write this code

Private Sub Form_Deactivate()
DoCmd.RunCommand acCmdSaveRecord
End Sub

[TheSmileyCoder]

1) Try compact and repair
2) Are you the only user in the database?

[AccessBeetle]

I forgot to mention but I already tried it 3 times. Did not work.
I am the only user, yes.
I even tried to make my own Navigation buttons. That did not help either.
Thanks for looking into it.
Please help!!

[AccessBeetle]

OK I found it
Refer this thread
http://support.microsoft.com/kb/278696

[TheSmileyCoder]

Please when posting provide:
Access version, and in your case I'd find it rather relevant to specify that your working of an SQL server.

Glad you found a solution, and glad you took the time to post it here :)