Access A Problem?

Discussion in 'ASP .Net' started by Curt Emich, May 9, 2004.

  1. Curt Emich

    Curt Emich Guest

    I've tried every possible combination of commands to insert a new record
    into an Access table, and it just won't happen. Does anyone know if Access
    has problems working with .NET?

    Check out this link:

    http://www.dotnetextreme.com/code/BasicAdo.asp

    This is the simplest code sample I've seen anywhere (book or Internet) to
    demonstrate how to insert a new record into an Access table (why finding
    such an example was like pulling a rhino's teeth is another issue). I
    copied the code almost verbatim (mine was VB instead of C#). No dice.

    I've made sure my security settings in the folder containing the Access
    database are not "read only", etc. Any other ideas, or is ADO.NET a red
    herring? I've noticed that a good many other experienced developers are
    having difficulty pulling off something this absurdly simple.
     
    Curt Emich, May 9, 2004
    #1
    1. Advertising

  2. Curt Emich

    jm Guest

    "Curt Emich" <> wrote in message
    news:...
    > I've tried every possible combination of commands to insert a new record
    > into an Access table, and it just won't happen. Does anyone know if

    Access
    > has problems working with .NET?
    >
    > Check out this link:
    >
    > http://www.dotnetextreme.com/code/BasicAdo.asp
    >
    > This is the simplest code sample I've seen anywhere (book or Internet) to
    > demonstrate how to insert a new record into an Access table (why finding
    > such an example was like pulling a rhino's teeth is another issue). I
    > copied the code almost verbatim (mine was VB instead of C#). No dice.
    >
    > I've made sure my security settings in the folder containing the Access
    > database are not "read only", etc. Any other ideas, or is ADO.NET a red
    > herring? I've noticed that a good many other experienced developers are
    > having difficulty pulling off something this absurdly simple.
    >


    Sorry if I missed it, but maybe you should post your error.


    ---

    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004
     
    jm, May 9, 2004
    #2
    1. Advertising

  3. Curt,

    The error will help to determine where the problem is.
    When you configure the OledbDataAdatper, it has all the code written inside
    the #Region section for Add, Delete, Update.

    Mark

    "Curt Emich" <> wrote in message
    news:...
    > I've tried every possible combination of commands to insert a new record
    > into an Access table, and it just won't happen. Does anyone know if

    Access
    > has problems working with .NET?
    >
    > Check out this link:
    >
    > http://www.dotnetextreme.com/code/BasicAdo.asp
    >
    > This is the simplest code sample I've seen anywhere (book or Internet) to
    > demonstrate how to insert a new record into an Access table (why finding
    > such an example was like pulling a rhino's teeth is another issue). I
    > copied the code almost verbatim (mine was VB instead of C#). No dice.
    >
    > I've made sure my security settings in the folder containing the Access
    > database are not "read only", etc. Any other ideas, or is ADO.NET a red
    > herring? I've noticed that a good many other experienced developers are
    > having difficulty pulling off something this absurdly simple.
    >
    >
     
    PC Trouble Shooter -->, May 9, 2004
    #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. luican
    Replies:
    3
    Views:
    12,390
    Aaron W. West
    Jun 4, 2004
  2. david
    Replies:
    2
    Views:
    1,655
    Ken Cox [Microsoft MVP]
    Nov 24, 2003
  3. Guest
    Replies:
    2
    Views:
    577
    Guest
    Feb 2, 2004
  4. Guest
    Replies:
    0
    Views:
    524
    Guest
    Feb 9, 2004
  5. MSDN
    Replies:
    0
    Views:
    692
Loading...

Share This Page