developing asp with Access database open

Discussion in 'ASP General' started by Nicolae Fieraru, Mar 29, 2005.

  1. Hi All,

    I have some asp pages which use a local Access database. I want to add
    different records to the database and also to be able to browse the page.
    When the database is open in MS Access, I can't open the asp pages, because
    I get an error (Microsoft JET Database Engine (0x80004005) Could not use '';
    file already in use.)

    I wonder if there is a way of being able to read records from the database
    in an asp script while the database is open in Access.

    Regards,
    Nicolae
     
    Nicolae Fieraru, Mar 29, 2005
    #1
    1. Advertisements

  2. "Nicolae Fieraru" <> wrote in message
    news:4248b92d$...
    > Hi All,
    >
    > I have some asp pages which use a local Access database. I want to add
    > different records to the database and also to be able to browse the page.
    > When the database is open in MS Access, I can't open the asp pages,

    because
    > I get an error (Microsoft JET Database Engine (0x80004005) Could not use

    '';
    > file already in use.)
    >
    > I wonder if there is a way of being able to read records from the database
    > in an asp script while the database is open in Access.


    http://www.aspfaq.com/show.asp?id=2009

    --
    Tom Kaminski IIS MVP
    http://www.microsoft.com/windowsserver2003/community/centers/iis/
    http://mvp.support.microsoft.com/
    http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
     
    Tom Kaminski [MVP], Mar 29, 2005
    #2
    1. Advertisements

  3. Thank you Tom,

    The link was useful, I did some reading and now it works fine

    My database is located in C:\Inetpub\wwwroot\MyWebs\db

    I had to set the security for IUSR_SERVERNAME to full control and now I can
    view the page and have the Access database opened in Access at the same time

    Best regards,
    Nicolae


    "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
    news:...
    > "Nicolae Fieraru" <> wrote in message
    > news:4248b92d$...
    >> Hi All,
    >>
    >> I have some asp pages which use a local Access database. I want to add
    >> different records to the database and also to be able to browse the page.
    >> When the database is open in MS Access, I can't open the asp pages,

    > because
    >> I get an error (Microsoft JET Database Engine (0x80004005) Could not use

    > '';
    >> file already in use.)
    >>
    >> I wonder if there is a way of being able to read records from the
    >> database
    >> in an asp script while the database is open in Access.

    >
    > http://www.aspfaq.com/show.asp?id=2009
    >
    > --
    > Tom Kaminski IIS MVP
    > http://www.microsoft.com/windowsserver2003/community/centers/iis/
    > http://mvp.support.microsoft.com/
    > http://www.iistoolshed.com/ - tools, scripts, and utilities for running
    > IIS
    >
    >
     
    Nicolae Fieraru, Mar 30, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. THY
    Replies:
    4
    Views:
    658
    Gönen EREN
    Aug 22, 2003
  2. =?Utf-8?B?dnZlbms=?=
    Replies:
    10
    Views:
    1,925
    Juan T. Llibre
    Oct 19, 2005
  3. damezumari
    Replies:
    0
    Views:
    658
    damezumari
    Mar 27, 2006
  4. =?Utf-8?B?a21jY29za2V5?=

    ACCESS AN ACCESS DATABASE FROM ASP.NET INTRANET SCENARIO

    =?Utf-8?B?a21jY29za2V5?=, Apr 24, 2007, in forum: ASP .Net
    Replies:
    7
    Views:
    695
    =?Utf-8?B?a21jY29za2V5?=
    Apr 30, 2007
  5. kmccoskey
    Replies:
    2
    Views:
    417
    Paul Clement
    Apr 27, 2007
  6. william

    Access remote access database from ASP

    william, Feb 10, 2004, in forum: ASP General
    Replies:
    5
    Views:
    254
    william
    Feb 13, 2004
  7. xg
    Replies:
    5
    Views:
    362
    Bob Barrows [MVP]
    Mar 20, 2006
  8. Replies:
    2
    Views:
    239
Loading...