Access 2000

Hi,
We have an app written in VB 6.0 front end and Access 97 backend . We wish to have the same app run against sql server. Pl. advice the best approach.
Eg: If I use MSDE (Microsoft Data Engine) instead of Jet 3.51, will the same code work against both db's with minimal changes ?

Thanks In Advance,
Santhosh.

[Vlad Chapranov]

I have some bad experience with that. I have 4 Data Controls in my project. I incerted DAO recorset objects between DC and Database because DC cannot work directly with Access 2000 db, changed reference from DAO351 to DAO360 and transfered my db to Access 2000 format. Everything was fine when I ran my project from VB. I made executable file. It crashes on those forms which contain DC. I had problems with Crystal Reports until Seagate issued Maintenance release.
So be careful, test everything before you make any global changes.
Vlad Chapranov

[rajeev_gupta]

how to execute a lengthy sql in a SQR with -M option.

[nilch]

If u have written code to open database and create recordsets, then u have less of a problem than if u have used Data control (DC).

Just change over from DAO to ADO to overcome such incompatibilities between access97 and 2000

With a code base app - define the database object as a new adodb.connection object instead, change recordset to new adodb.recordset.
Then redefine the connection.open (to SQL database) and recordset.open methods (follow ADO techniques).

There will be other minor changes like useing findfirst method, filter method etc, but minor. Rest of app should work as it is.