You can use Access as a front end to almost anything via ODBC. On the machine with Access, create an ODBC connection to your foreign database - this assumes that the database is accessible via the network. Then you can either link to or import the foreign database, depending on your needs.
If the database is not accessible via the network, you are down to writing a query to generate a delimited file and sneakering it to the Access machine. At 03:13 PM 2/13/2002 -0700, you wrote: >----- Original Message ----- >From: "Carlisle, Eric" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, February 13, 2002 2:47 PM >Subject: RE: MySQL Cold Fusion Question? > > > > Would you want to convert so you can easily view table data? If so, it >may > > be better to have Access link to mySQL tables via ODBC. Access works well > > to view mySQL table data. Not sure about actual conversions, though. > > >Can you explain how to link from Access via ODBC to another database. For >example, I'm working at Machine A, and the MySQL database resides on Machine >B (with CF server, IIS, etc.). I've got an ODBC datasource set up on >Machine B for use by CF. Where do I create the Access database? If I try >creating the Access DB from machine A, and try to link via ODBC, I can only >see ODBC datasources located on the local machine. On the server itself, I >don't have Access installed. > >Thanks, >Jim ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
