On Sat, Aug 1, 2009 at 10:25, AG wrote: > The dB will be for field studies of fungi and I am conscious that should I > wish to share these data with anyone from the mycology field, it is probable > that they will be using MS Access.
* Microsoft has been trying to end of life Access for at least five years, and probably longer; * In terms of cross platform capability, SqLlite is the reigning champ. There isn't a platform that it isn't available on. (It also is the most widely deployed database engine in history.); > how well would a dB in Base translate to those using MS Access, and what > would be the best way of sharing that data? Depending upon the data, the migration process can range from "straightforward", to "extremely non-trivial." My working assumption is that migrating anything into, or out of MS Access is going to result in data corruption, that requires somebody to verify each field in each record, to correct the corruptions that occur. >would something like MySQL be a better option? That Depends upon how many records and tables your database has. If one of your criteria is to pass users one file, then SQLite is a better choice than MySQL. If, OTOH, your expectation is to have a dozen or more tables, and several million records in each table, MySQL is a slightly better choice. jonathon --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
