On Wednesday, October 9, 2002, at 08:34 PM, Brett Frisch wrote: > I finally understand where you're coming from on this. I do have a > quick > question for you: > > In your initial question you stated that you made a cf script convert > the > access DB into ms sql or oracle. How did you convert that info back > to the > access DB file? I haven't used access in a long time and never heard > of > that. I could actually use that for one client right now. >
Brett Traditionally, you would dump to a CSV file, etc. With the OpenLink setup, you can process the MS-Access database, with CFMX, just as you would any other online db -- create,drop and populate tables--- so you could use the original MS-Access tables, delete all the records, then repopulate them from the online data (denormalizing in the process if necessary). Again, one big advantage is that all the logic is contained in program(s) that are repeatable -- if you need to do this every quarter, just run the programs. I have one client that has a web-centric database -- totally maintained on line. At the end of the year they need to make offline MS-Access copies of the database for reporting and statistical analysis. Some of the data is given to their clients and outside firms for analysis, marketing, etc. MS-Access is an excellent common denominator for this purpose -- and they do not expose the online database (SQL-Server , in this instance). I am really jazzed to have this capability on the (non-windows) desktop, and to be able to choose a Host platform without limiting it to one that can manipulate MS-Access dbs. Stated simply -- CFMX on OS X or Linux can now use MS-Access dbs! Dick ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
