sameermaira
12-15-2005, 02:36 PM
Hi ,
I have an ASP page with an access database. The form updates the database when SUBMIT is pressed. Everything works fine.
I uploaded the whole page on a free server and tried Submitting the page and it works. HOWEVER , when 2 or more people access the same page I get an error.
Server Error
The following error occurred:
Could not connect because of networking problems. Contact your system administrator.
Please contact the administrator.
I assume this has something to do with the Table Rights and permissions. The following is a copy of the code.
[CODE]
<%@ Language=VBScript%>
<% Option Explicit %>
<!--#include file="adovbs.inc"-->
<!--#include file="DatabaseConnect.asp"-->
<%
Dim objRS,email
Set objRS=Server.CreateObject("ADODB.Recordset")
objRS.Open "info", objConn, 3, 3
Here is the Database Connect file included in the above code
<%Dim objConn,DSNName
Set objConn=Server.CreateObject("ADODB.Connection")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("db/users.mdb")
objConn.Open DSNName
%>
Since the web page is going to be open for Registration to a number of people, they might log on to the site at the same time and register. I want to make sure they are allowed to do so. I know the LOCK settings for the TABLE "info" would have to be changed but I dont know which settings would be best for my use.
It would be great if someone could let me know of a solution.
Thanks
:rolleyes:
I have an ASP page with an access database. The form updates the database when SUBMIT is pressed. Everything works fine.
I uploaded the whole page on a free server and tried Submitting the page and it works. HOWEVER , when 2 or more people access the same page I get an error.
Server Error
The following error occurred:
Could not connect because of networking problems. Contact your system administrator.
Please contact the administrator.
I assume this has something to do with the Table Rights and permissions. The following is a copy of the code.
[CODE]
<%@ Language=VBScript%>
<% Option Explicit %>
<!--#include file="adovbs.inc"-->
<!--#include file="DatabaseConnect.asp"-->
<%
Dim objRS,email
Set objRS=Server.CreateObject("ADODB.Recordset")
objRS.Open "info", objConn, 3, 3
Here is the Database Connect file included in the above code
<%Dim objConn,DSNName
Set objConn=Server.CreateObject("ADODB.Connection")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("db/users.mdb")
objConn.Open DSNName
%>
Since the web page is going to be open for Registration to a number of people, they might log on to the site at the same time and register. I want to make sure they are allowed to do so. I know the LOCK settings for the TABLE "info" would have to be changed but I dont know which settings would be best for my use.
It would be great if someone could let me know of a solution.
Thanks
:rolleyes: