Jim Lawrence
accessd at shaw.ca
Tue Jan 4 02:33:39 CST 2005
Hi Christopher: Use DTS to import the data but in most cases the queries will have to be manually re-created into Stored Procedures. Reports, now they are a whole other ball-game...check out http://www.databaseadvisors.com/newletters/newsletter112003/0311UnboundRepor ts.htm as it might help. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher Hawkins Sent: Monday, January 03, 2005 4:33 PM To: accessd at databaseadvisors.com Subject: [AccessD] One-click upsizing and downsizing of Access to SQL Serverand back? This is a strange request. Bear with me. I have a client who I am taking from an Access back-end to a SQL Server backend. Not having any previous experience with SQL Server, my client is nervous, and no amount of explaining or references will calm him. He's asked me to build some sort of routine so that if the SQL Server goes down, he can "downsize" back to An Access back-end with a single button click. He also wants to be able to re-upsize with a single button click. If he's willing to pay for the hours, I may as well. It might turn out to be a fun project. ;) I usually do my upsizing with the Upsizing Wizard. I am aware of DTS but have used it only sparingly. Have any of you done anything like this before? -Christopher- -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com