If you're looking to backup the database, why not backup to SQL Server format? SQL Server does have the capability to make scheduled backups of existing databases.
For downsizing to an Access DB, you can develop a DTS Process to copy the tables to an Access DB. If you're using some of SQL Servers more complex goodies, keep in mind that they may not downsize to Access. All things being equal, though, I'd suggest you just backup to a SQL Server db. EC -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 9:13 AM To: CF-Talk Subject: Downsizing from SQL2000 to MS Access A client wants to have a backup copy of Access 2000 on his local machine, for piece of mind (its his life's work). The site db is SQL 2000. Does someone know of an automatic routine to copy, on the fly, from SQL 2000 to Access. Or is the only solution when doing adds | updates | deletes to various tables from CF is to run the processing twice in the same template, once for SQL, once for Access? Thanks, Mark ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
