Donate SIGN UP

Dreamweaver / Access

Avatar Image
NickleArse | 15:23 Thu 12th Jun 2003 | Technology
9 Answers
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????
Gravatar

Answers

1 to 9 of 9rss feed

Best Answer

No best answer has yet been selected by NickleArse. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Question Author
P.S. I am hosting the site on a Windows 2000 Server running IIS if that helps.
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.
Question Author
Ok thanks lisaj. Just wondered if there was something obvious I had overlooked. I will delve a little deeper into the depths of dispair.
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.
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).
Question Author
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.
Interrogating, not interegating.
Question Author
mmmmm, ok.
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..

1 to 9 of 9rss feed

Do you know the answer?

Dreamweaver / Access

Answer Question >>