RE: Problem with an ASP script accessing an .MDB file.

[garymgordon]

I am having a problem and need help.

I have 3 scripts that are simply accessing an .mdb file, reading it and outputting the data to an asp page for display on a webpage. (One script for each type of search. Meaning one to search by last name, one to search by first name and one to search by the department someone works in.

Problem: When I simply rename the .mdb file and re-upload it to the server, the script fails. We then have to re-boot the server in order for things to come back up. Nothing else .. just reboot the server.

So, I am presuming that something might be written poorly in the script that is not closing the connection down or the recordset, etc.

I need someone to review the scripts and tell me what is wrong with it .. and how to possibly tweak it a bit to make it better (if possible), and more secure.

Please contact me if you would be willing to take a look at it.

Thanks,
Gary

Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/

 

[GaryC123]

is it too big too post here? Saturday 12.00

20.00

3.00am

Sunday [img http

 

[garymgordon]

GaryC123,

Yes.

Can you catch me on MSN Messenger? garymgordon@hotmail.com

Thanks,
Gary
Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/