When connecting to an ACCESS database i am getting a SQL error "[ODBC Microsoft Access Driver] Record(s) cannot be read; no permission on 'TABLENAME'.
How do I sepcify the WorkGroup database which will permits reading from .mdb databases?
OK, I figuered it out. Connection to Workgroup secured ACCESS databases has to be done via OLEDB Provider for ODBC Drivers.
Follow the instructions there to create the link to the Workgroup manager and then connect to the required ACCESS database
Retrieving data ...