--- Jason Clinton [email protected] wrote:
On Tuesday 3 May 2005 10:59, Leo Mauler wrote:
Is that easier to convert from Access to SQL or easier from SQL to Access? (I think I know the answer, I just want to hear it from someone who does this professionally)
Well, I'm not a professional DBA but I sometimes play one. In the past I have used MySQL's ODBC driver to connect MySQL tables to Access so that Access reports and such could use the MySQL data as a source. Those tables that are linked-in appear in the list of tables just like any other Access table. It's not "copied"; every time Access needs info from those tables it sends it to the ODBC driver which contacts the MySQL server which handles the query.
Which seems to be the answer I thought it would be: "make it a SQL database, you'll enjoy it so much more later." :)
The question is: is there an ODBC driver for the two that you want to use?
I don't know, having just got into the Exciting World of Databases myself. If ODBC drivers are excessively complex I may either tell them to find a real database programmer or just do the whole thing up in Access.
I guess what I'll end up using is SQLite, as the poster who mentioned it said that it has an easy learning curve. Sounds like the best thing to do is "do the whole thing up in SQLite and muck through the ODBC drivers as best I can".
Actually, I think there's a web guy who might already have a MySQL database up and running, I'll ask him too.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com