Use the data trranformation services to downsize to Access that should make
it work fine. You may have to change some sytax but that's it.
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: Dana Larose [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 2:41 PM
To: [EMAIL PROTECTED]
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.
