Authentication Error

Hi,

I've connected to an Access Database through ADODC. Whenever I run a SQL query, I get a messagebox that says "Authentication Error". What could be the problem?

~ rat

Probably that you have enabled User-level security in Access, but have not parsed a username/password in your ADODC connection string.

Of course it could be something more bizarre, you know what MS are like with their error messages :D

It's not a access restriction problem; I am sure of that.

Earlier, this program ran fine, but now when I open it, it is giving me this error.

Anyone Else?

I bumped into this problem myself not so long ago. Try installing the latest MDAC (Microsoft Data Access Components) I believe 2.6 is the latest ver. Then you should be fine.
You can get it here : http://www.microsoft.com/data

Regards,
Surgeon

I just downloaded ver. 2.6, but the problem persists. Can anyone else offer insight on this?