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

Christopher Hawkins clh at christopherhawkins.com
Mon Jan 3 18:32:52 CST 2005


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-

 



More information about the AccessD mailing list