Michael Sumner
Tue, 09 Oct 2007 13:15:28 -0700
This is kind of a what if.
The President of our company used to be the only tech person and he loves Access. We have a half dozen Access DBs floating around - some linked, others stand alone with some of the same data. This is after I got rid of 5 that used to be used for the website. Here is a list of what we have and its primary use: MySQL - website and primary location of member records Progress - used by the ERP for member orders, AR, AP and General ledger for the company Access - primarily used to manage Vendor Program records (terms and discounts they give our members) the merchandising dept primarily uses these for their processes of managing vendor attendance to our trade shows. There are numerous reports, and forms used to update information - He uses Access as its own IDE to build apps. There is a lot of manual keying from trade show to show. There are many queries that get built and run once and never deleted - make finding the ones that are good difficult. We have to export a large quantity of this info to post to the website. MSSQL - primarily used by the document management package to house and index what used to be paper files, Its secondary process will be to house description and index information for an eCommerce module that will talk to the Progress DB. We have CPU licenses since this will be exposed to the web. Most of the DBs do connect together for a piece of information here and there. I have used CF to access the Progress backend for a PO submittal app, and to allow internal users access to update some data. The Access DBs access the Progress DB pretty heavily - the President loves to build Access Reports, and he uses it to make some updates to the Progress DB What would you use as the primary DB platform? What would you use to unify, where appropriate the applications - internal web application, Flex, Desktop Windows Development connecting to fewer DBs Not that I am looking for work to do, but I think it time to pull things together. Again I appreciate the time and the insight. Michael Sumner Nations Best Sports 817-788-0034 ext 244 817-788-8542 fax
_______________________________________________ Reply to DFWCFUG: List@list.dfwcfug.org Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/