Imdabaum
04-28-2010, 10:55 AM
In the past I have had Oracle as a backend and I haven't really had many issues that way. Now I'm working with SQL Server and having some troubles.
Linked table to SQL server table1.
Form2 RecordSource = table1
I open form2 from a button on form1. The problem is that the first time I click the button, form2 opens and allows me to enter data freely. If I miss any data and have to open the form again, it locks the record. I have tried several solutions recommended by Microsoft (refreshing links with ADODB connection and forcing the DoCmd.RunCommand acCmdSaveRecord).
Any insight would be wonderful.
Linked table to SQL server table1.
Form2 RecordSource = table1
I open form2 from a button on form1. The problem is that the first time I click the button, form2 opens and allows me to enter data freely. If I miss any data and have to open the form again, it locks the record. I have tried several solutions recommended by Microsoft (refreshing links with ADODB connection and forcing the DoCmd.RunCommand acCmdSaveRecord).
Any insight would be wonderful.