Christopher Hawkins
clh at christopherhawkins.com
Tue Jan 4 12:39:14 CST 2005
I think his idea is that I use the most recent backup. This is possibly the goofiest thing I have ever been asked to do. But I'm going to take a stab at it. If nothing else it might be fun. ---------------------------------------- From: DWUTKA at marlow.com Sent: Tuesday, January 04, 2005 8:51 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] One-click upsizing and downsizing of Access to SQL Server and back? Just out of curiousity, how do you downsize 'back' to an Access database from a SQL Server database, if the SQL server database is down? I think that would be a little difficult, no matter how well you code, unless you are constantly writing out to an .mdb somewhere. Drew -----Original Message----- From: Christopher Hawkins [mailto:clh at christopherhawkins.com] Sent: Monday, January 03, 2005 6:33 PM To: accessd at databaseadvisors.com Subject: [AccessD] One-click upsizing and downsizing of Access to SQL Server and 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com