I was finally able to create my ODBC connection but now when I go to External Data > ODBC > LINK TABLES using my ODBC connection in Access 2007 I get a huge list of tables such as
INFORMATION_SCHEMA.CHECK_CONSTRAINTS INFORMATION_SCHEMA.COLUMNS INFORMATION_SCHEMA.DOMAINS
and a whole bunch of
sys.all_columns sys.all_objects sys.all_parameters
the only tables that i really need are tables such as
dbo.users dbo.stats dbo.customers
but none of those tables are on the list of table that I am able to choose from to link.
Does anyone know why I can't see or link to the DBO tables I need?
(by the way i created a new user login in order to create my ODBC connection)