Data Entry form and ADO?

[jadixon]

I am converting an existing Access application to use SQL server. I have a form that in the current application, opens a table in data entry mode (datasheet view). Since access creates an autonum when the user starts to enter data, the developer who created it decided at that point to add 600000 to the autonumber to create another field (please don't ask why). Anyway, I know that in order to get the autonum value (identity) from SQL I must use ADO to get it. The problem is that when I put the connection code in the open form event, I get all records and cannot add one - just the opposite of what access naturally provides in a data entry form (an empty window with the ability to add data).

Is there any way to get the form to act like the old access way using ADO?

 

[jadixon]

Oh, I forgot to mention we are still running with Access 2000, so I have a feeling the updating data part of the ADO connection may not be available (and we are not planning to upgrade yet - again, don't ask).