[AccessD] MySQL be and Access FE

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




More information about the AccessD mailing list