Switching from Access to SQL5

I was asked to do a project using VB6 and MS Access.
But now the client has decided that it needs to be done with SQL5.

I don't have SQL and have never worked with it.

Could I write the program on my machine, using Access till I get it debugged, then switch to SQL?
If so, what kind of changes would need to be made?

The program will used on several remote computers that will all connect to the same DB on a server.

whenever ur migrating database that time u have to take care abt connectionstring. There will not be more changes in queries cause Transact sql queries almost same. But u have to check output of the queries.

I just found out you can download SQL5 express for free.

So the only difference will be the connection string?
Can someone show me an example of an SQL connection string?

"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=MyServer"

www.connectionstrings.com
this will help u.. I have doubt abt queries but Trasact SQL will not affect while changing any database. There will be hardly any differance.

But there will be differences. Don't ship until you've run it through with the database it's going to be used on.