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.