-
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'
-
Note
Just a note there is an mdw file associated with the mdb that I am accessing. I don't know if this has anything to do with it... What do you think?
-
Read Access
Do you have read access to the table if you go in via Access? Are you actually making a connection? Maybe the database is secured and you need to login.
Not too sure with Access 2000 as we are still on '97 here.
Paul.
-
Check in access on extra, options -> advanced.
Look to see if your settings are ok.
If the settings are good, then look at the file attribute
on your mdb file.
Cheers
Ray