access and sql using same code

[sitmapa]

vb6
access 97
sql 2000
i have a app using access 97, i want conect and access data to sql,

i need convert any code from my app, or i can use the same code for access data to sql

thank´s for any idea or helppp

 

[HarleyQuinn]

You will have to change your connection string and (depending how you have done them in the original code) probably some of the qualifiers in your queries as a start...

Harleyquinn

---------------------------------
For tsunami relief donations