469,898 Members | 2,349 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Error 80004005

5
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??????
Aug 8 '06 #1
7 41969
sashi
1,754 Expert 1GB
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.. :)
Aug 9 '06 #2
samah
5
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:
Aug 10 '06 #3
sashi
1,754 Expert 1GB
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.. :)
Aug 10 '06 #4
sashi
1,754 Expert 1GB
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..
Aug 10 '06 #5
samah
5
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
Aug 16 '06 #6
samah
5
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
Aug 16 '06 #7
i think the problem is coz of this symbol <>

With rs
.Open "SELECT * FROM Table1 ", db, adOpenForwardOnly, adLockOptimistic
End With
Jul 13 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Christophe Cerbourg | last post: by
1 post views Thread by Richard | last post: by
6 posts views Thread by Rowan | last post: by
2 posts views Thread by ago | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.