How similar is ADO & MDB to ADO & SQL

[airbaal]

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

[paulw]

Can be as simple as that, you need to:

1. Design your system properly, so that it can scale
2. Design your system properly, so that it can scale
3. Design your system properly, so that it can scale


and

4. Take design into account.

Seriously, make sure you don't rely on Access 'wizards'. You will end up with table schemas that are hard to upsize.

Make sure your data is properly normalized. The actual details of using ADO against and MDB or SQL Server are a small part. Incidentally, ADO uses the Access standard wildcards, ven when querying against a SQL Server DB!

Cheers,

P.