I am converting a long working Access project to SQL Server

The problem is that it is riddled with DAO Commands and also the DAO Data Control

Most DAO commands can be converted to ADO resonably easily, except for FIND, FIND NEXT, SEEK of which I have a quite few.

There are quite a few forms which use the DAO Data Control

My instincts tell me to abandon the use of Data Controls (Even though I could use the ADO Data Control in place of the DAO Data Control) and simply use SQL Commands, which is going to treble the amount of work to do the conversion

Any comments appreciated