ODBC conection not showing user tables

[rsbutterfly16]

hi guys i am having an issue with my sql server. Now everytime i create a new database and i create a odbc conection to this database from my access front end for the user i only see the system tables and not the tables i created, is there something i am missing?

 

[SQLBill]

Does your login have access to the databases?

-SQLBill

Posting advice: FAQ481-4875

 

[rsbutterfly16]

yes i gave him read and write rights to the database.

 

[rsbutterfly16]

also when i try to conect from the access front end to the table in my new database , i get ODBC – call failed. (Error 3146).