I built my ASP using PWS and an Access 2000 database. I am now ready to move the application to my ISP who supports SQL server 7.0. I tried the upsizer in Access 2000 and it asked me to specify which SQL server I want to upsize to... Of course, I don't have SQL server installed.<BR><BR>How do I upsize without having SQL server installed?? Can I install an evaluation version of SQL server (available from Microsoft) and upsize, then upload my new SQL db to my ISP?<BR><BR>Also, I'm sure I will need to modify my ASP to work on the server. I currently execute SQL commands in the following way:<BR> set conn = server.createobject("ADODB.Connection")<BR> conn.open "orders" ' my db name is orders... <BR> set rs=conn.execute(SQL)<BR><BR>How would I rewrite this code to work with SQL server? <BR><BR>Thanks SO MUCH for your help.