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

SQL is a lot more stable than Access. It sounds as if
he might of had some instability or corruption
problems in the past. If he truly fears the
possiblibility of SQL server going down, there are
many tools already built for the purpose that are
available, or as others have mentioned mirroring of
drives and or servers.

If you STILL going to do it, you could run a job on
the SQL server that backs up every hour or so and copy
that back up file to a PC somewhere. Using MSDE on a
PC somewhere you could execute a stored procedure
which would run the restore of the database on this
box and change your ADPs connection to this box.

Fugly, but it would work.

David

--- Christopher Hawkins <clh at christopherhawkins.com>
wrote:

> 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
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>