Database connection works on and off!!

[mow]

Hello,
I am developing a set of simple webpages that connect to an access database. Everything worked fine. Then I copied all my files to a new location (same machine) and I get an error:
Microsoft JET Database Engine (0x80004005)
Unspecified error

This error occurs where it tries to open the database (same database as before!) with "objConn.Open strConnect". I've reached my wits end trying to figure out what the problem could be.
The other funny thing is that it works sometimes - after a couple of 'backs' and 'refreshes'. Any ideas???

Thanks.

 

[onpnt]

is it written like this with the "" in place
objConn.Open "strConnect"
not
"objConn.Open strConnect"
I know you may have just referenced it this way but that may may it work sometimes and not others. If thats not it we need a little more then this line of code.


I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[mow]

thanks. i was only using the quotes to reference my line of code. it's just
objConn.Open strConnect

that line has worked quite well for me. then i copy the entire ASP file to another location, try to run it, and then it only runs sometimes. do you think it might be a problem with the IIS?

-mow