[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