A bit past the sell-by date on this one, but here's my 2c worth... I'm an Access fan, and given all the (perfectly sound) reasons Nick gave for preferring MySQL over Access, I'm now asking myself, "why?" - apart from the fact that it's the devil I know ;-) Here are the things that come to mind: 1. I can easily cut code to tweak the data in VBA - but then again, I could also link MySQL tables and do it that way, so this doesn't count. 2. Wizards for complex queries - but I could run them and then port the code to MySQL, so this doesn't count either! 3. Crosstab queriy support for data roll-up is built-in, with a great wizard - does MySQL have this? Apart from that, it sounds like MySQL knocks the socks off it in terms of functionality. <rant> And of course, MySQL wasn't hobbled by Microsoft as a web db in later MDAC releases which arbitrarily limit the number of active connections to an Access db for no good reason that I can see, and also prevent changes to data in Access 97 db's, also seemingly for no good reason!! To me, it seems like both of these moves were designed to "encourage" web designers into buying MS-SQL Server, and/or upgrade to Access 2000+. But maybe I'm being too suspicious? </rant> HTH David -- David Landy, IT Consultant, Business Intelligence Somerfield/KwikSave Support Centre Whitchurch, Bristol, UK. Tel: 0117 301 8977 david.landy at somerfield.co.uk <mailto:david.landy at somerfield.co.uk> This is the true joy of life. The being used for a purpose Recognized by yourself as a mighty one. George Bernard Shaw If you are not the intended recipient of this e-mail, please preserve the confidentiality of it and advise the sender immediately of any error in transmission. Any disclosure, copying, distribution or action taken, or omitted to be taken, by an unauthorised recipient in reliance upon the contents of this e-mail is prohibited. Somerfield cannot accept liability for any damage which you may sustain as a result of software viruses so please carry out your own virus checks before opening an attachment. In replying to this e-mail you are granting the right for that reply to be forwarded to any other individual within the business and also to be read by others. Any views expressed by an individual within this message do not necessarily reflect the views of Somerfield. Somerfield reserves the right to intercept, monitor and record communications for lawful business purposes.