Invalid Object name: Acccess 2000 Premium

[Dököll]

Greetings, Good buddies!

This one is kind of simple but I am not able to figure out. I am gettting this error:

Invalid Object name... I have no idea why I am not connecting to the Server, tests went fine.

Here is a query, skillfully written:-)

 
SELECT * FROM Email;
 
 

Here is my ODBC connection:

 
ODBC;Description=MySQLData;DRIVER=SQL Server;SERVER=.\SQLEXPRESS;Trusted_Connection=Yes
 
 

I should perhaps tell you the system asked to save password info to ODBC string, I said heck no, so I got the above.

Also I am not sure if because the DataSource not listed in the string is the problem. Not certain why the Description would show and not the...

Wait a second, I can just plug it in...

Hang on

[Dököll]

No, same deal... I tried:

ODBC;DataSource=MeSQLData;DRIVER=SQL Server;SERVER=.\SQLEXPRESS;Trusted_Connection=Yes

That did not work. What are your thoughts.

The ODBC connection said it was successful upon set up, and tested.

Thanks!

Dököll