In article <44CP1BNR$6YDFwyF@shrdlu.com>, Bernard Peek <bap@shrdlu.com> wrote:
>In message <KBoTbXAEYQXDFwO6@shrdlu.com>, Bernard Peek <bap@shrdlu.com>
>writes
>>In message <43562c2c$0$24648$4fafbaef@reader3.news.tin.it>, Giuseppe
>>Maxia <gmax_@_cpan_._org> writes
>>>Bernard Peek wrote:
>>>> I have a small SQL Server database with a lot of tables. I'd like to
>>>>migrate the data to MySQL on the same Windows server. Is there a
>>>>Windows-based utility that can copy table structures between the two
>>>>databases, or even transfer the tables structure and data too?
>>>>
>>>
>>>Yes: the MySQL Migration Toolkit.
>>>http://dev.mysql.com/downloads/migra...olkit/1.0.html
>>
>>Thanks. That's only a Release Candidate but it did the job in a few
>>minutes.
>
>Having migrated the database from SQL Server to MySQL 5 I want to use MS
>Access 2000 as a front-end. Unfortunately none of the windows ODBC
>drivers seem to work. The current stable release of ODBC drivers
>silently fail without returning any data. The latest alpha release just
>gives me an error message, it's a known bug according to the web site.
>
>Can anyone help me to attach MySQL 5 tables in Access 2000?

I'm running MySQL 5.0.13-rc on a FreeBSD box, and was able to
attach to it using the MyODBC 3.51.11 driver from the MySQL
web site. It pretty much Just Worked.

Uh, (ahem) with Access 2002. If upgrading is an option for you...
--
Steve Watt KD6GGD PP-ASEL-IA ICBM: 121W 56' 57.8" / 37N 20' 14.9"
Internet: steve @ Watt.COM Whois: SW32
Free time? There's no such thing. It just comes in varying prices...