• I presume what you are doing is creating an ODBC Data Source from Control Panel - such connections are often called DSNs just to confuse the issue. You should start by creating a User DSN, not the System one - if you are running Win7 or later. You do specify a database name, which can be the same as or different from the SQL Server database name you want to connect to. You then use the drop down combo box to specify the SQL Server system and instance. Dropping it down does a browse to find all the SQL Server instances it can, and should produce a list as long as you can connect to one or more. Chose the one you want and then step through what security you are going to use and select the actual SQL Server database if it isn't your default, and finish by testing whether you can connect. Once that is done, you should be able to get the upsizing wizard to work. You can also upsize an Access database from SQL Server - the general concensus is that the SQL Server tool works better, but I personally don't see much difference.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!