I am at my wits end. I thought I knew what I was doing but apparently I don't. I am sure I am missing a very simple step but just can't figure it out.
I am attempting to link tables to a new Access database project. I click New table/Link Table/OK. When the link pop up appears, I select ODBC Database(). Nothing happens. I don't get a list of tables. I don't get an error message. I can continue to repeat these steps until I am blue in the face.
If you have an ADP then you will need to connect to data using File/Connection. It is different than an MDB. With an MDB you can link many different tables from many different sources. With an ADP you connect to a SQL Server database and that is it. You cannot have local Access tables or any other linked tables. When you connect to a SQL Server database, you will see all the tables, views and stored procedures in that database.
If you need to connect to more than one source then I think you will have to work with an MDB. The advantage of an ADP is that SQL Server does the heavy lifting (SQL). With an MDB it is done by Access.