Having a problem with database search

[noycwild]

I put in a search word through the web page and click search and get this error.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/addresssearch_db/NPANXX_Ownership/Utilized_NPANXX_Ownership Search Results.asp, line 23

Can anyone specify what the error is? Does it have to do with the code on my asp page or is it have to do with something with connectivity to my database?

[juliemac]

Do you have the database open while trying to access it?
Access can remain open but the table its self needs to be closed.

BTDT. Drove me nuts for a while

[johnrswanton]

post ur code n il have a look at it 4u

[noycwild]

If IsObject(Session("DB_conn")) Then
Set conn = Session("DB_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DB","",""
Set Session("DB_conn") = conn
End If

[MarkDorf]

I'd bet money that juliemac nailed the issue on the head.

[noycwild]

I'd bet money that juliemac nailed the issue on the head.

I checked and the table and database is not open on any computer or server. Any other ideas? Could it be the web hosts side and not mine?

[noycwild]

/bump still having problems, i'm still waiting on a reply from my web host...the only thing i can think of because i looked up on microsoft.com and 3 causes are web host side and 1 cause is what you guys said before about the table or db being open and they are not. Any suggestions thoughts? Thanks

[johnrswanton]

try
conn.close
to close database after search
after 'wend'

[noycwild]

try
conn.close
to close database after search
after 'wend'

I did try this, still didn't work.
Great idea! This would be useful, but it would only work if the database was being opened in the first place. The thing is it was working for a long time and all of a sudden it stopped working and gave me the error you see above. Still waiting on the web host to respond. Thanks for the input.

[mendhak]

Are there any .LDB files in the same directory as the MDB database?

[noycwild]

Are there any .LDB files in the same directory as the MDB database?

I checked and no there is not any .LDB files. The database is not opened and none of the tables in the database are open.

[noycwild]

Thanks for the help....it did end up being the webhost side making the problem.