ADO Read Problems

[VBDever]

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'

[VBDever]

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?

[paulw]

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.

[marex]

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