jonathon wrote:
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.);
Wasn't aware of SqLlite - so will look into that one.
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.
That would just be a royal PITA by anyone's standards
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.
The criteria would be something reasonably straightforward to use so
that I can focus on the data rather than the database, where I can store
and call up related images if required as exemplifying a particular
concept/ term, and something that is potentially extendable. I had also
wanted something in which I could have an entry form with drop down
menus if required for various common choices to be made. That's why I
thought of Base, on the assumption that I would be able to do this set
up. I know very little about MySQL, except that the last time I used it
a number of years back it was all from the command line, whereas I think
some kind of GUI (even ncurses) would be preferable.
jonathon
Thanks.
AG
