Re: Access97 DB locks up the asp code at times
From: joker (no-spam_at_netzero.com)
Date: 08/09/04
- Next message: Serge Myrand: "Re: Problem sending mail (CDOSYS)"
- Previous message: Curt_C [MVP]: "Re: Problem sending mail (CDOSYS)"
- In reply to: ziggs: "Re: Access97 DB locks up the asp code at times"
- Next in thread: ziggs: "Re: Access97 DB locks up the asp code at times"
- Reply: ziggs: "Re: Access97 DB locks up the asp code at times"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 09 Aug 2004 08:37:29 -0600
The .ldb file is created when the database is accessed & deleted after
you have finished with the .mdb file.
ziggs wrote:
> 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
>
>
- Next message: Serge Myrand: "Re: Problem sending mail (CDOSYS)"
- Previous message: Curt_C [MVP]: "Re: Problem sending mail (CDOSYS)"
- In reply to: ziggs: "Re: Access97 DB locks up the asp code at times"
- Next in thread: ziggs: "Re: Access97 DB locks up the asp code at times"
- Reply: ziggs: "Re: Access97 DB locks up the asp code at times"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
