RE: [Sheflug] Re: Access to MySQL

["Morris, David (Allvac, UK)" <david [at] xxxxxxxxxxxx>]

> -----Original Message-----
> From: Richard Ibbotson [mailto:richard [at] sheflug.co.uk] 
> Sent: 15 June 2003 11:43
> To: shef-lug [at] list.sheflug.org.uk
> Subject: [Sheflug] Re: Access to MySQL
> 
> 
> Matt
> 
> Thanks to everyone and Matt for the helpful advice..

Just to add my (late) two pennorth, I'd go with the MyODBC cut 'n' paste
suggested by Adam.

We use MySQL / MyODBC / Access against a daily snapshot of our main
production (non-relational) database for abusers [sic] to write their
own queries.

It should be as simple as linking Access into the MySQL database tables,
copying, pasting and unlinking the tables - certainly from a point of
getting the data across anyway! As already identified, you problems will
probably then start!

Good luck.

-- 
David
___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.