|
From: John F. <in...@al...> - 2004-04-15 00:11:18
|
What I have is a rather old access database that is used by a proprietary WinNT program that collects data from various machines and stores it in the database. Presently, the .mdb file is about 160 megs of largely numbers (counters, levels, timers, etc.) Several of these numbers are of great interest to us and we've been using the (proprietary software) to generate a report each day based on the previous day's numbers and storing those values in another database I've created using PHP / MySQL. The MySQL database provides much more meaningful information, and I am trying to automate the process of extracting the information we need from the access database. (It also allows much [more] information to be gleaned from it's contents than even the reports give us so there are numerous advantages) However, given the size of the database, and the fact that each day's information is heaped on top of years of previous days' records (at about 700 rows / day), you can imagine what I wouldn't give to be able to do a "SELECT * FROM process WHERE date = CURRENT_DATE" instead of trying to parse years of information for one day's data. :) The long and the short of it is that yes, I would be more than happy to help test the new code once it's ready for trial. John Finlay IT Systems Manager Custom Linen Systems Ltd. 2925 10th Avenue N.E. Calgary, Alberta T2A 5L4 Email: in...@al... |