ASP/ADO/AccessDB Refresh Problem

D

Dave

Hey,

I'm running a localhost web server...W2K with IIS 5.0, and I'm trying to use
ASP/ADO to access my Access database. When I first load the page, everything
works, but if i hit refresh (F5 or even Ctrl-F5), I get "page cannot be
displayed" with the problem line of code being the database Open command
(the starred line in the snippet below). If I press Refresh repeatedly, that
doesn't help. After a minute or two, refreshing the page does access the
database, but then the problem begins again with the very next refresh. I'm
not sure where the problem is...in Access, ASP, ADO, IIS, or something
important I left out of the HTML. Has anyone experienced this?

Thanks,
Dave

<snip>

<%@ Language="JScript" %>
<html>
<head>
<title>DataBase Fun!</title>
</head>
<body>
<%
Session.Timeout = 15;
conn = Server.CreateObject("ADODB.Connection");
**********conn.Open("obdc_exmp");
%>

<%
strSQLQuery = "SELECT * FROM names";
rs = Server.CreateObject("ADODB.Recordset");
rs.Open(strSQLQuery, conn, 3, 3);
%>

<%
while (!rs.EOF)
{
Response.Write(rs("last_name") + ", " + rs("first_name") + "<br>");
rs.MoveNext();
}
%>

<%
rs.Close();
rs = null;
conn.Close();
conn = null;
%>
</body>
</html>

</snip>
 
D

Dave

Could be Access. Access has very limited strength when it comes to dishing
out data online.
Access would is best suited for sharing data online if you set it up to
generate a basic html page around midnight (every night if needed). (Look
into using the OS Task Scheduler to automatically call the database file and
to close the file.) Then during the day people only be pulling the html page
and not putting any demand on Access.
You could then set up a Data Access Page (Access 2000 and above) to update
the database from within the office. (Data Access Pages are really useful on
an intranet basis. You can use them on the internet provided the user is
known. (You could update the database from home.))

Dave
 
D

Dave

Don't recall if I emailed directly.
Look into using SQL (in place of Access). SQL can support many simultaneous
users in real time.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top