Nancy Lytle
nancy.lytle at auatac.com
Sun Jul 27 17:37:46 CDT 2003
I have inherited multiple databases, and the number is growing. The databases are small but contain import information (important, not mission critical). I am splitting those that are not already split and using FE Autoupdater. My problem At this point is that the databases are all over the network making it harder to administer. I have no say at this point in where the databases are located. I would like to get everything consolidated so I can more easily handle backups, checking data integrity, etc. The best way I can see to do this would be to use MySQL for the BEs and Access for the front end. This way I will have all the data in one location that will be easy(ier) to administer and I can concentrate on the front ends. Does this sound like a plan? (I am choosing MySQL for its price - we do not need the additional capabilities of SQL Server for these databases). Any other suggestions welcome. TIA -- Nancy Lytle EIS nancy.lytle at auatac.com