I know. But it's fast and when customers use MySQL, then you flow with it.
Strictly as a GUI interface only. Liek select a row and paste huge
quantity of data that customers sent to update their database, etc. All
done at once and I get them most of the time in excel and sometime in
Access. So, select all data, and paste in Access link to MySQL via ODBC
and all is pasting all at once oppose to Open Office for example that
will and can only do one row. Think of it as a quick interfcae of
editing directly the database records. If oyu edit only one record, then
you can do somethng else, but dong multiple one, then it's still the
fastest way.
It's a speed of usage issue for multiple row editing. I can do quick
edit directly with MySQL client in the DB, but when it comes to multiple
rows entry, etc. If you get the data in either from and then try to
convert in SQL statement for import and all. It takes way to much time
to do it and in the end, What I do in 30 seconds would take a very long
time doing it like that. It's a practical data editing and entry that
it's used for. And again Access is only and strictly use for it's
capability of GUI edit/paste only. And obviously I still need it to read
the data I get obviously.
I know the idea looks stupid. I grant you that. (;> But if you ever see
it, you would see that it is darn quick and save countless hours and as
time is always missing in my days, anything that same me some will be
strongly consider. Plus ODBC is pretty darn old to and looks like places
start to drop it's usage too. It's a very limited usage and I really do
not care for any features of Access, etc. I could care less for it. As I
sai,d I only and strictly use it as a GUI over ODBC to edit records
directly in the remote database. Nothing else.
I may not explain myself very well I agree. Sometime I have problem
doing so. but that's all there is to it really. Nothing more then that.
That's why it looks to stupid doing so and replacing it should be very
simple. But I just do not have an alternative for it and I looked for
many years! That is really the only thing I still have that force me to
keep VMWare, Microsoft and Access on a MAC for example. Everything else
have been replaced and I do not have an alternative yet on an OpenBSD
desktop. A very small price to pay, but never the less still stuck with it.
