Retrieving data from ACCESS database

[deep2389]

Hi,
I have a sample ASP code which should get the records from a table in ACCESS database. However, while running the page I am getting the following error:

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."

The code which I have is:

<%
Dim rs
Set rs = Server.CreateObject ("ADODB.Recordset")

rs.Open "My Table", "DSN=My Database"

While Not rs.EOF
Response.Write "ID : " & rs("id") & "<br>"
Response.Write "First Name : " & rs("first_name") & "<br>"
Response.Write "Last Name : " & rs("last_name") & "<br>"
Response.Write "<br>"

rs.MoveNext
Wend

rs.Close
Set rs = Nothing
%>



Can anyone please help me rectify this??

Thanks,
deep2389

[shweta123]

Hi,

Please check if the table you are updating or database(.mdb file) is opened
previously. Close the database in order to remove the error.

[jhardman]

deep,

do you have a database connection object? (it isn't in the code listed above) I think your "set rs..." line might be technically incorrect without it. The syntax should be something like this:

Dim rs, conn
    set conn = server.createobject("ADODB.Connection")
    conn.open "DSN=myDatabase"
    Set rs = Server.CreateObject ("ADODB.Recordset")
    rs.Open "SELECT * FROM myTable", conn

I always do something more like this. I realize that there are potentially many different ways to do this, but I get few errors connecting this way. Let me know if this helps.

Jared