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. Advertising

  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. 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. MSDN
    Replies:
    0
    Views:
    688
  2. Fernando Lopes
    Replies:
    0
    Views:
    870
    Fernando Lopes
    Mar 29, 2005
  3. JC
    Replies:
    3
    Views:
    605
    =?ISO-8859-2?Q?Dra=BEen_Gemi=E6?=
    Jun 19, 2006
  4. Sree
    Replies:
    8
    Views:
    316
    Netocrat
    Dec 19, 2005
  5. Tony Johansson
    Replies:
    7
    Views:
    527
    Gregory A. Beamer
    Dec 23, 2009
Loading...

Share This Page