Re: Access97 DB locks up the asp code at times

From: ziggs (ziggs_at_hotmail.com)
Date: 08/08/04 

Date: 8 Aug 2004 14:07:12 -0500

Thanks for the quick reply.

Almost all employees are set to read only, so I would assume that one
of these users created the query off the asp and that's the problem.
I'm not sure why, but I could never see the employee.ldb on the folder
so I never could check that. Thus, it most likely is the permissions
problem with the folder.

>From memory, to answer your questions that I neglected to detail out
(sorry), the error message was:

Error Type: (0x80004005)
Unspecified error
employee.asp, line 6

Thus, it was pointing to the line of:

"my_conn.Open ConnString"

that I was referring to but didn't detail out.

I'll chat with our IT group about setting the proper permissions.
Unfortunately, I haven't had much luck in the past describing what I
actually need since I'm obviuosly weak in this area.

If you have any specific advise I can pass on, I would appreciate it.
The four current groups are Administrators, Everyone, Managers, and
System under the Security tab. Your suggesting to add at least the
IUSR_MachineName account name.

I guess my main problem is that I'm not positive about the correct
combination settings to use for the web sharing, sharing and security
areas. My goal is that everyone can run the asp that accesses the mdb
but not be able to open or view the folder off any share, Managers can
open the share and change the mdb and Administrators obviously have
full control to all.

On Sun, 8 Aug 2004 14:05:30 -0400, "Bob Barrows [MVP]"
<reb01501@NOyahoo.SPAMcom> wrote:

>ziggs wrote:
>> 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")
>
>Nothing to do with your problem, but you should be using the native Jet
>OLEDB provider instead of the ODBC driver:
>
> ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
>& Server.MapPath("employees.mdb")
>
>The ODBC provider has been deprecated.
>
>>
>> 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.
>
>What problem?
>
>> 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".
>
>What error code? What error message? You're asking us to solve your problem
>blindfolded.
>
>
>If I had to guess, and I do, I would guess that you have a permissions
>problem. All database users, including the IUSR_MachineName account, need
>filesystem read/write permissions on the folder containing the database
>file. Users must be able to create, modify and delete the .ldb locking file
>in the folder containing the database. It is not enough to grant permissions
>for the database file.
>
>Bob Barrows

Relevant Pages

  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • Re: Shared v. Exclusive Access
    ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
    (microsoft.public.access.security)
  • Re: Display of Message "You do not have eclusive access toa databa
    ... > in the foder that has the database. ... >> permissions on the folder, then have one of them open the folder in ... >> permissions on the folder. ... >> Ian Shaw wrote: ...
    (microsoft.public.access.security)
  • Re: Database issue
    ... Permissions on the folder ... If you have an ISP that has a server type database, ... Second, even if you persist each hit to the database, I am not sure why ...
    (microsoft.public.dotnet.framework.aspnet)
Loading