PDA

View Full Version : Solved: New SQL user



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.

Imdabaum
04-30-2010, 09:56 AM
A: BIT must have default value in SQL Server.

Sorry should have marked this solved a while ago.
I got all the bits but one... fixed the last one and "BAZINGA" we're gold.