Access web site problem

D

digger27

OK, so here's the problem. I am building a web site based on our Access DB.
I have the ASP code working and am merely working on the colors and designs
for the "pretty-fication" of the site. However, there is one problem with
the DB. Whenever I open a page that pulls data from the DB, I have to wait
30 seconds before I can click on a link to other data.
A simplified example: Let's say you go to an automotive site looking for a
part for your car. First you click on a link for the make (Ford, Chevy) of
your car. This then queries the DB and pulls a list of models for that make.
You then click on the list of models and get a list of years, and so on. We
have something like this, only we have to wait 30 seconds between each level
or I get an error referencing a line in my ASP code.

Any ideas on why this is and how to eliminate it?
 
J

Jörg Ackermann

Hi,

digger27 schreibselte:
OK, so here's the problem. I am building a web site based on our
Access DB. I have the ASP code working and am merely working on the
colors and designs for the "pretty-fication" of the site. However,
there is one problem with the DB. Whenever I open a page that pulls
data from the DB, I have to wait 30 seconds before I can click on a
link to other data.
A simplified example: Let's say you go to an automotive site looking
for a part for your car. First you click on a link for the make
(Ford, Chevy) of your car. This then queries the DB and pulls a list
of models for that make. You then click on the list of models and get
a list of years, and so on. We have something like this, only we
have to wait 30 seconds between each level or I get an error
referencing a line in my ASP code.
Click to expand...

What version is your DB?
How do you connect to Database (connect string)?

Acki
 
D

digger27

I the DB is Access 2000, but was built using Access 2002.
I am using a system DSN connection.
 
Top