access database

Discussion in 'ASP .Net' started by Hai Nguyen, Jan 14, 2004.

  1. Hai Nguyen

    Hai Nguyen Guest

    with access database

    1/ How can we insert mutiple row into a table at the same time?
    2/ is it possible a table in access database to have more than one primary
    key?

    Thanks
     
    Hai Nguyen, Jan 14, 2004
    #1
    1. Advertisements

  2. Hai Nguyen

    Miha Markic Guest

    "Hai Nguyen" <> wrote in message
    news:%...
    > with access database
    >
    > 1/ How can we insert mutiple row into a table at the same time?


    I don't think jet oledb driver supports batch operations.
    You might use a query as a stored procedure though.

    > 2/ is it possible a table in access database to have more than one primary
    > key?


    Primary key is one and only. Why do you need another one?

    --
    Miha Markic - RightHand .NET consulting & software development
    miha at rthand com
    www.rthand.com
     
    Miha Markic, Jan 14, 2004
    #2
    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. MSDN
    Replies:
    0
    Views:
    808
  2. Fernando Lopes
    Replies:
    0
    Views:
    973
    Fernando Lopes
    Mar 29, 2005
  3. JC
    Replies:
    3
    Views:
    732
    =?ISO-8859-2?Q?Dra=BEen_Gemi=E6?=
    Jun 19, 2006
  4. Sree
    Replies:
    8
    Views:
    476
    Netocrat
    Dec 19, 2005
  5. =?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:
    688
    =?Utf-8?B?a21jY29za2V5?=
    Apr 30, 2007
  6. Replies:
    1
    Views:
    1,117
    Thomas Fritsch
    Apr 30, 2007
  7. Kenneth McDonald
    Replies:
    0
    Views:
    560
    Kenneth McDonald
    Feb 7, 2009
  8. Tony Johansson
    Replies:
    7
    Views:
    772
    Gregory A. Beamer
    Dec 23, 2009
Loading...