ASP and Access database--error loading

[Dave K.]

Hi everyone,

I'm relatively new to databases and such...so please bear with me

I'm designing a web page for my charity; the page is going to list the
parenting programs we offer. I figured I'd do a simple MS Access 2002
database and post the info from the database onto the web page using ASP.
The database simply has information on our programs such as the program
name, dates offered, text description of the program, and building location.
There are only about ten programs in the database. (First question--is this
the best way to do this? Or is there a better way, especially given how
small the database is?)

Everything seemed to be going swimmingly. I entered three programs' worth
of data just to test it out, and the ASP web page loaded perfectly. I could
even hit "Refresh" and the page would reload without any errors.

I noticed the database file size was getting a tiny bit large (500KB, after
I had only entered three programs' worth of data!), so I chose to do
"Compact and Repair". This lowered the file size to 144KB. I then uploaded
the database to the webserver.

Now, when I go to the ASP web page, it loads the page without any problems
as it did before; but if I *refresh* the page, now it gives me an error:

Provider error '80004005'
Unspecified error

/programs.asp, line 29


Hmmmm. OK, line 29 points to a line of code in my ASP page which reads:

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("APFAprograms.mdb")

I usually then have to wait about a minute; then, if I reload the web page a
second time, the page loads normally again.

I have the sinking feeling I've done something silly, but I don't know
enough about all this to figure out what it could be. Does anyone know what
I'm doing wrong?

Thanks!
Dave K.

 

[Marvin]

check the permissions on the uploaded access db, ASP might not have
authority to open it.

 

[Dave K.]

check the permissions on the uploaded access db, ASP might not have
authority to open it.

Marvin,

Thanks for your reply...I did check the permissions, and there's nothing
that would indicate a permissions problem. Besides, it does get loaded the
first time--it's just on a refresh that it gets hung up. Then it works
again when refreshing a second time if I wait a bit.

Dave