Help.
I can connect to my ADO db just fine its an access 2000 db. However when I try to run the 1st SQL statement that I have I get an error saying that I don't have read access to the table I am trying to do a select from.

Here are the specifics

Connect string:
.ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & strPath

All seems to work fine here, I a connection and am able to open.

Code bombs after the following line:
mRS.Open "SELECT * FROM fe_TransferList", mCN, adOpenKeyset, adLockOptimistic

I get this message:
Runtime error '2147217911 (80040e90)'
Record(s) cannot be read; no read permission on 'fe_transferlist'