Once you have migrated the tables/queries etc from Access to SQL server why can't your VB6 application link to SQL server directly?

OK, I see what you are saying.

I think you may be worring. I have found Access links to SQL back ends with very few drop outs.

How often is a server name changing? It should not be...

Perth and Western Australia are having somewhat of a boom time due to the demand for Iron Ore. This is having a flow on effect and DBA skills are in...