Unanswered: Cannot see Oracle table when linking from Access
I have a table called MyTbl on an Oracle Express db that I want to link to from Access. Here's what I did: in Access (2007) I went to External Data -> ODBC Source -> Link... -> Machine Data Source and added Microsoft ODBC for Oracle. Then entered my username, db name (XE), and password and was hoping to see my table in that gigantic list of Oracle tables. But it wasn't there. In Oracle I have made sure that the user has ALL privileges to MyTbl.