Hi Simon,

If you sign into Query Analyser as the user you are using in the ODBC Wizard can you see and query all the tables you want to?

Also are you sure that your SQL Server is installed to use both Windows authentication and SQL Server Authentication?

Just a couple of thoughts.

Jon