I am writing a database program in ADO 2.5 with VB 6.0 EE. I plan on writing it with Access 2000 databases, and then maybe also have a SQL Server database version. My question is how difficult is it to modify for the SQL version? Is it just basically:

a) connection string differences
b) wildcard differences -- % vs. *

? Or is it a lot more involved than that?

Also, where is the best place to purchase SQL Server?

Thanks in advance,

Eric