Trouble Converting an Access 2000 database to SQL 7.0

[Arnold]

I am trying to convert an Access 2000 database over to SQL 7.0, but I am having some problems. I ran the upsizing wizard to upsize the table structure and link the database tables to the sql 7.0 tables. That worked fine. I then imported all the data into the SQL 7.0 backend. Again no problems. But when I tried to run my main menu form, I got an error that said, &quot;Run-time error: 3622. You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.&quot; After getting the error I changed my &quot;dbOpendynaset&quot; code to &quot;dbSeeChanges&quot;, but I got a new error that said, &quot;Run-time error 3001, Invalid Argument.&quot; The line of code that gets the error is as follows:<br>
<br>
Set RcdTemp2 = dbcurrent2.OpenRecordset(&quot;TempPurchaseOrderItem&quot;, dbSeeChanges)<br>
<br>
RcdTemp2 is defined as &quot;Recordset&quot;<br>
dbcurrent2 is defined as &quot;Database&quot; and is set to <br>
&quot;CurrentDb()&quot;<br>
<br>
I also got this error:<br>
&quot;[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit column (#252)&quot;<br>
<br>
Got any ideas?<br>
<br>
Arnold<br>
<br>

 

[Arnold]

I found out what was wrong with my &quot;dbSeeChanges&quot; command, it goes after the &quot;dbOpendynaset&quot; command. They are both in the statement.<br>
<br>
I still haven't solved my &quot;Cannot group by a bit column&quot; problem yet. So if you could help me out with that one, that would be great.<br>
<br>
Thanks<br>
<br>
Arnold

 

[accc]

Change the bit column to be char (length:1), and use