Access web site problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
hello friend..i noticed your post and if you dont mind id like to ask a
question? Im sorry i cant help you out but you seem to have done what i
want to do!

myself and a friend are building a databse, which is almost complete. We
need to be able to link a form on a webpage to the database as part of our
project but we just dont know how...can you offer any guidlines? would be
so much appreciated..heres my email if you can..but if youd rather not
thats ok..all the best anyway

mike_gsxr[AT]hotmail.com
 
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
 
I the DB is Access 2000, but was built using Access 2002.
I am using a system DSN connection.
 
Back
Top