Error 80004005

[samah]

I have a package i used it for 3 days ago and then i got these 2 error
Run Time Error unspecified error ( 80004005)
and Run Time Error Could not lock file ( 80004005)

and these are my codes with ADODB connection

Dim db As AdODB.Connection
Dim rs As Recordset

Set db = New AdODB.Connection
Set rs = New AdODB.Recordset

With db
.CursorLocation = adUseClient
.Provider = "Microsoft.Jet.OLEDB.3.51"
.Open "db297.mdb", "admin", ""
End With

With rs
.Open "SELECT * FROM Table1 where ID <> 0", db, adOpenForwardOnly, adLockOptimistic
End With


rs.AddNew

rs("Action") = ("Success Verification")


rs("Date") = DateTime.Month & "/" & DateTime.Day & "/" & DateTime.Year
rs("Time") = DateTime.Hour & ":" & DateTime.min & ":" & DateTime.Sec
rs.Update

Set DataGrid1.DataSource = rs
DataGrid1.Refresh

rs.Close
db.Close
and database in Access 97 as my customer request , i do not if the problem will be solved if i use Access 2000 or Access 2003

can any one advice me??????

[sashi]

Hi there,

runtime error 80004005 refers to unrecognized database format.. what is the version of your access database? use Jet Ver 4.0 for access 2000/2003.. Jet 3.5.1 for access 97.. take care my fren.. :)

[samah]

Thanks for your reply, i used this provider

Provider = "Microsoft.Jet.OLEDB.3.51" in my codes and my db is with
Access 97 as my customer needs :confused:

[sashi]

Hi Samah,

if that's he case.. are you able to open the access db with your ms-access software? this is just to make sure your db isn't corrupted.. if the problem continues.. try creating the db all over again with exact structure and save it as access 97 format.. take care and good luck my fren.. :)

[sashi]

Hi Samah,

i almost forgot to ask you abt the MDAC component you are currently using.. MDAC ver 2.1 is perfect for access 97 db.. check that out too..

[samah]

Hi Samah,

i almost forgot to ask you abt the MDAC component you are currently using.. MDAC ver 2.1 is perfect for access 97 db.. check that out too..

Hi Sashi

Thanks for your reply and iam sorry for this delay time, I used MDAC ver. 2.5 , i do not have MDAC ver 2.1 , do you have it or do you know in which site can i find it?????pls reply me soonest

[samah]

Hi Shashi,

I read that MDAC 2.1 is used for Windows 98 , is it?????
Im using WindowsXP and also my client so Iam confused :rolleyes:

Thanks

[dio1316]

i think the problem is coz of this symbol <>

With rs
.Open "SELECT * FROM Table1 ", db, adOpenForwardOnly, adLockOptimistic
End With