Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
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?
Thanks
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