Z
ziggs
I have an Access 97 DB called employees.mdb within a NT security type
folder. Other users have write privileges to this document to make
updates. This Access DB is only used for an ASP called employee.asp
that's within the same folder. Here's the connection string example:
<%@ Language=VBScript %>
<% Dim my_conn, rs
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="
& Server.MapPath("employees.mdb")
Set my_conn = Server.CreateObject("ADODB.Connection")
my_conn.Open ConnString
set rs = server.CreateObject("ADODB.Recordset") %>
This asp has been working without major problems for about 2 years.
On most occasions, a user can open the Access DB, make changes and
close it without any problems. However, on two occasions, a problem
has occurred after a user opened the Access DB. My only guess is that
someone accesses the employee.asp, which queries the Access DB when
the Access DB is opened and being changed. Once this occurs, the
employee.asp delivers an error code and complains about the connection
line of "my_conn.Open ConnString".
Any idea why this is happening? To correct the problem, I can just
rename the employees.mdb to another name like employees1.mdb and then
change connection string in the employee.asp to "ConnString =
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("employees1.mdb")", from employees.mdb
Anyway, I would like the users to still have the ability to be able to
modify the MS Access DB if possible so that I don't have yet another
thing to do.
Any thoughts?
Thanks
folder. Other users have write privileges to this document to make
updates. This Access DB is only used for an ASP called employee.asp
that's within the same folder. Here's the connection string example:
<%@ Language=VBScript %>
<% Dim my_conn, rs
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="
& Server.MapPath("employees.mdb")
Set my_conn = Server.CreateObject("ADODB.Connection")
my_conn.Open ConnString
set rs = server.CreateObject("ADODB.Recordset") %>
This asp has been working without major problems for about 2 years.
On most occasions, a user can open the Access DB, make changes and
close it without any problems. However, on two occasions, a problem
has occurred after a user opened the Access DB. My only guess is that
someone accesses the employee.asp, which queries the Access DB when
the Access DB is opened and being changed. Once this occurs, the
employee.asp delivers an error code and complains about the connection
line of "my_conn.Open ConnString".
Any idea why this is happening? To correct the problem, I can just
rename the employees.mdb to another name like employees1.mdb and then
change connection string in the employee.asp to "ConnString =
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("employees1.mdb")", from employees.mdb
Anyway, I would like the users to still have the ability to be able to
modify the MS Access DB if possible so that I don't have yet another
thing to do.
Any thoughts?
Thanks