Besides the fact that one access SQL Server and the other is for other ODBC data sources, is there any syntactical difference besides the actual connection string to connect to the database?<BR><BR>For example, if I want to do this, and it works with Access, will it work in SQL Server with a simple find/replace for ADO with SQL?<BR><BR>Dim myConnection as ADOConnection <BR>Dim myCommand as ADOCommand <BR><BR>myConnection = whatever<BR><BR>myCommand = new ADOCommand("INSERT into friends (firstNAME,lastname) VALUES (&#039;David&#039;,&#039;Johnson&#039;)", myConnection) <BR>myConnection.Open() <BR>myCommand.Execute() <BR>myConnection.Close()