That appraoch interests me. An initialization method that runs when the user starts the app. It checks the available connections and then updates a file which the connection string reads...

Thanks Jeffrey. I'll investigate the compare options but first please clarify "create a new database" Do you mean manually recreate each table one field at a time?. Is there a...

Yes of course a script would be best. I am using sql2008 what are the steps to create this script?

SSMA for 2008 Works great. (2005 version didn't) Note: to install the program you will need to download a small lisence file and put it in the SSMA program...

Same Deal. Access2007 won't upsize to SQL2008

error "The upsizing wizard only works with microsoft sql server (version 6.5 SP5 or Higher). Please log in to a SQL Server Datasource"