Microsoft JET Database Engine error

[charon]

I have been spending so much time to find out what is going wrong with the my OLEDB database connection:When i'm trying to use OLEDB provider for access ((objDC.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & ";uid=;pwd=1234") ), below problem occur:

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.

I'm using win2k

1.) I have already checked my pc to confirm there has MDAC component. It has -> msrd3x40.dll in the C:\\Winnt\system32

2.)I have alreday tried to re register again the dll (Regsvr32 c:\winnt\system32\msexcl40.dll)file, but still face the same problem

3.) I try to installed service pack3, result in three msrd3x40.dll files, but failed to connect

4.) Try to use data link -> seems like can work, but have problem
Error Type:
Microsoft OLE DB Service Components (0x80030005)
Access Denied.

I hv already tried all the access permission, none is succeed

pls advice!

[charon]

DEAR ALL,
after a long discussion, and spent so much time,my problem only because of this:

objDC.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & ";uid=;pwd=1234" -->In correct

objDC.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & ";Jet OLEDB:Database Password=1234" -> Correct

But, I found that the SQL statement which can be executed with ODBC, can't be executed in OLEDB

For instance:
"SELECT * FROM control"
I have error :
Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause.

"INSERT INTO Names (Name) VALUES ('Rose')"

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.

[Roy Sinclair]

Look at this (http://www.adopenstatic.com/faq/80040e21.asp) article to see if anything there applies (it looks to me like at least one of them will be of help).