How to connect ASP.Net to access database

Discussion in 'ASP .Net' started by buzz, Jun 15, 2005.

  1. buzz

    buzz Guest

    I've tried to use the Data Wizard to connect to the Northwind sample database in Office. I can preview the data in the data adapter, but when I run the ASP page I get this error....

    The Microsoft Jet database engine cannot open the file 'C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb'. It is already opened exclusively by another user, or you need permission to view its data.


    Any help or links to resolve this would be appreciated......


    --------------= Posted using GrabIt =----------------
    ------= Binary Usenet downloading made easy =---------
    -= Get GrabIt for free from http://www.shemes.com/ =-
    buzz, Jun 15, 2005
    #1
    1. Advertising

  2. That usually means that the ASP.NET account doesn't have Modify privileges
    where the Access file is located. Access needs to open a locking (.LDB) file
    so the current account has to have the right to create the file.

    "buzz" <> wrote in message
    news:SyKre.42246$...
    > I've tried to use the Data Wizard to connect to the Northwind sample
    > database in Office. I can preview the data in the data adapter, but when I
    > run the ASP page I get this error....
    >
    > The Microsoft Jet database engine cannot open the file 'C:\Program
    > Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb'. It is already
    > opened exclusively by another user, or you need permission to view its
    > data.
    >
    >
    > Any help or links to resolve this would be appreciated......
    >
    >
    > --------------= Posted using GrabIt =----------------
    > ------= Binary Usenet downloading made easy =---------
    > -= Get GrabIt for free from http://www.shemes.com/ =-
    >
    Ken Cox [Microsoft MVP], Jun 15, 2005
    #2
    1. Advertising

  3. Hi Ken,

    I am developing an asp.net application using c# and asp.net 2.0 beta 2. I
    started developing this page usign beta1. In beta 1 I have written some code
    in Page_LoadComplete(object sender, EventArgs e) events of page. It was
    working fine. But after I installed beta 2.0 Page_LoadComplete events is not
    firing at all. Can u guide me how can I achieve this goal?

    Thankx in advance.
    Shailesh.

    "Ken Cox [Microsoft MVP]" wrote:

    > That usually means that the ASP.NET account doesn't have Modify privileges
    > where the Access file is located. Access needs to open a locking (.LDB) file
    > so the current account has to have the right to create the file.
    >
    > "buzz" <> wrote in message
    > news:SyKre.42246$...
    > > I've tried to use the Data Wizard to connect to the Northwind sample
    > > database in Office. I can preview the data in the data adapter, but when I
    > > run the ASP page I get this error....
    > >
    > > The Microsoft Jet database engine cannot open the file 'C:\Program
    > > Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb'. It is already
    > > opened exclusively by another user, or you need permission to view its
    > > data.
    > >
    > >
    > > Any help or links to resolve this would be appreciated......
    > >
    > >
    > > --------------= Posted using GrabIt =----------------
    > > ------= Binary Usenet downloading made easy =---------
    > > -= Get GrabIt for free from http://www.shemes.com/ =-
    > >

    >
    >
    >
    =?Utf-8?B?U2hhaWxlc2g=?=, Jul 13, 2005
    #3
    1. Advertising

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. SSP
    Replies:
    1
    Views:
    2,977
    Jeff Cochran
    Jul 1, 2003
  2. Patricia Kline
    Replies:
    1
    Views:
    580
    Oliver
    Oct 25, 2003
  3. Mat Smart
    Replies:
    0
    Views:
    210
    Mat Smart
    Feb 1, 2005
  4. Arne Vajhøj
    Replies:
    0
    Views:
    856
    Arne Vajhøj
    Feb 19, 2012
  5. Replies:
    2
    Views:
    279
Loading...

Share This Page