Jeff,
I remember struggling with this. The only way I was able to export tables
AND relationships was by exporting the database into SQL script. Then, to
upload this into Access. I've since forgotten how to execute SQL directely
into Access, but setting up an ODBC and executing from a some SQL-capable
client should work.
Leon Oosterwijk
ISDN-NET
-----Original Message-----
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 3:09 PM
To: CF-Talk
Subject: RE: MS SQL DB to MS Access
Well I have successfully "downsized" my SQL DB to Access. But none of the
relationships were exported, is it possible to do this?
TIA,
Jeff
-----Original Message-----
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:12 PM
To: CF-Talk
Subject: OT: MS SQL DB to MS Access
Hi all,
I have a DB in MS SQL and want to export it to MS Access to make some
modifications, then I plan to upsize it again.
I am familar with upsizing Access to SQL but not the other way, from SQL to
Access.
Thanks for any help,
Jeff
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
