Hi to everybody Does anybody rec

[unicorn11]

Hi to everybody

Does anybody recognise this error
why does it come and my database is not corrupt because i have just opened to and checked it

Microsoft JET Database Engine error '80004005' 

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. 

/abhi/data_acc_user_1.asp, line 18

my connection string and my recordset string are as follows

 Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Open "Data Source=" & Server.Mappath("backup.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"

  set rs_access = server.CreateObject("ADODB.RecordSet")
  rs_access.Open sql_access, conn, 1, 2

Regards : Unicorn11
abhishek@tripmedia.com

[red]Life is a stream who's source is hidden[red]

 

[iqof188]

Try this, see if it works (the difference is that a driver is specified):

<%
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot
DSNtemp=&quot;DRIVER={Microsoft Access Driver (*.mdb)}; &quot;
DSNtemp=DSNtemp &amp; &quot;DBQ=&quot; &amp; Server.MapPath(&quot;backup.mdb&quot
conn.Open DSNtemp

set rs_access = server.CreateObject(&quot;ADODB.RecordSet&quot
rs_access.Open sql_access, conn, 1, 2
%>

Hope this helps...

<webguru>iqof188</webguru>

 

[unicorn11]

This is the error that it gave

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3c4
Thread 0xc34 DBC 0xae26024 Jet'.

/abhi/data_acc_user_2.asp, line 23

Regards
Unicorn11
abhishek@tripmedia.com

[red]Life is a stream who's source is hidden[red]

 

[iqof188]

What version of Access are you running, and what version is the DB table?


<webguru>iqof188</webguru>