database

[Leo Mauler]

--- Jason Clinton <me at jasonclinton.com> 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