[AccessD] One-click upsizing and downsizing of Access to SQL Server and back?

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





More information about the AccessD mailing list