Dreamweaver / Access

[NickleArse]

I am interegating an access database using dynamic content in dreamweaver. I enter the surname of an employee in the search box and click submit which takes me to an ASP results page with the details of all the employees with that surname. but if I go back to the submit page and try again within about 3 minutes the search won't work. I get a 'Page cannot be displayed' error. Can anyone help me...It works fine again if I leave it for a while????

[NickleArse]

P.S. I am hosting the site on a Windows 2000 Server running IIS if that helps.

[lisaj]

Going to be hard to diagnose without knowing precisely what kind of ASP implementation you've got running, IIS modules, etc. You might want to look at file handles for the Access DB file before, during and after the search to see if there's something untoward there. Try inserting some ASP printlines to give some progressive output as the search takes place so you'll get a better idea of where it's failing.

[NickleArse]

Ok thanks lisaj. Just wondered if there was something obvious I had overlooked. I will delve a little deeper into the depths of dispair.

[anthomson]

Ensure that the connection to Access is being properly closed before exiting the ASP page. Access isn't designed for multiple simultaneous connections so if the connection isn't being dropped between searches it could soon grind to a halt.

[lisaj]

I second that. anthomson's suggestion sounds like the most likely culprit of these symptoms with this (and any other DB scripting) problems (ie. not closing DB links after use, or filehandles).

[NickleArse]

Thanks guys. Unfortunately my knowledge of Access is limited to say the least. I had it opening for exclusive access not shared. Changed it and it has done the trick. Thanks again.

[Spellmaster]

Interrogating, not interegating.

[NickleArse]

mmmmm, ok.

[nmr]

Can I suggest installing MySQL & MyODBC - then simply upload your Access database to MySQL and go from there, it'll be a lot more robust and a lot easier to use..