Just write a cg page that dumps the SQL7 databases you need into access, and
have him then download the access file to his local laptop. Then he doesn't
have to change anything. I assume he had to periodically get copies of the
Access files before, so all you have to do as add one little step to the old
process.
HTH,
Peter Janett
Director of Interactive Media
http://www.healthwell.com
[EMAIL PROTECTED]
----- Original Message -----
From: Dana Larose <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 12:41 PM
Subject: A** Backwards Conversion :)
> I know this goes against all reason and common sense, but here is goes...I
> have a client who has an Access-based system, and wants to upgrade it to
SQL
> Server. However, he keeps a local installation on a laptop, so he can
demo
> his site to clients.
>
> After we move to SQL Server, he will still want the demo copy on his
> notebook. Since I can't justify his purchasing a license for SQL Server
> Enterprise for a laptop, I need to know if there is an easy way to convert
a
> SQL Server db to an Access file.
>
> I can probably avoid (or work around) using triggers or stored procedures,
> so I just need the db structure, data and relationships replicated.
>
> Dana Larose
> ColdFusion Monkey
> Canadian Web Design & Consulting Inc.
>
> A: 701-281 McDermot Avenue (McDermot & King)
> P: 204.946.5155
> C: 204.228.0477
> F: 204.946.5156
> E: [EMAIL PROTECTED]
> W: http://www.cdnwebdesign.com
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
