Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unhappy Unanswered: Web Access Integration = asp.net ???

    I am interested in using an Access 2003 database on a Windows 2000 Server running IIS to track customers, employees, transactions, etc. I have created a intranet site and can see the data in Dreamweaver Mx, but when I open the site in Internet explorer I get an error:

    Open the mom.saci.com home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP
    errorInternet Information Services
    -- Error Type:Microsoft OLE DB Provider for ODBC Drivers
    (0x80004005)[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet
    database engine cannot open the file '(unknown)'. It is already opened
    exclusively by another user, or you need permission to view its
    data./TMP2iouqug3wh.asp, line 5 Browser Type:Mozilla/4.0
    (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)
    Page:GET /TMP2iouqug3wh.asp Time:Thursday, March 11, 2004,
    8:17:05 PM More information:


    I did think that asp is the best way to handle web/access integration.......
    any advice?????

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Here's a good connections resource and if you have trouble with the exact wording of a connection you may want to go with a DSN.

    Able Consulting - ADO Connection String Samples
    http://www.able-consulting.com/ADO_Conn.htm
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    And here is something I put together about ASP that hopefully might help somehow.

    Web Database Concept
    http://www.bullschmidt.com/concept.asp
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •