Database search question

[Paul M]

Hi
Does the database connection terminate when the results
of a search on an Access database With a form created by
the results wizard have returned.
If not how can I make it happen.
How many concurent searches can an access database handle
at any one time and what happens when this limit is
exceeded.
best wishes
Paul M

 

[Thomas A. Rowe]

What errors are you seeing?

Access can handled 255 simultaneous connections/queries.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Paul M]

Hi
There are no errors. I read somewhere that you have to
teminate the connection to a database using code or the
connection will remain until it times out is this true?
If so I does the results wizard search form code
terminate the conection or will I have to add some code
myself, If so can you point me in the right direction
Best wishes
Paul M

 

[Thomas A. Rowe]

I don't use the FP database components, so I can not say if it does or does not.

If you have other pages using the same database connection, then I wouldn't close the database
connection, just the specific recordset. The examples below will need to be modified to handle FP
naming convention for the connection.

Close Connection:
<%
Connection.Close
Set Connection = Nothing
%>

Close Recordset:
<%
fp_rs.Close
Set fp_rs = Nothing
%>

I normally place these after the closing </html>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================