[ASP3]Cannot connect to database 2nd time
I have a page that connects to an Access database successfully, displaying all the rows on the page. However, if I hit refresh, I get an error on the line number where I'm opening the connection to the database. If I wait a while, it works.
I have another page that displays a subset of data from the same table and it also shows an error for the line number where the connection is opened.
If I am on the page that shows the whole table, and click a link to go to the subset table, I will get the error. The same is true the other way around. If I wait a while between opening pages that use the table, the page connects as it should.
I close both my connection and recordset and set both of these to Nothing at the end of the document.
What causes me to not be able to connect a second time without waiting?
I am new to ASP, so I hope this doesn't sound stupid. It is hopefully some easy thing I am missing, and hopefully my description may be enough so someone here can tell me what I should do or what topic to read up on!
Thanks, all!
|