SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Access DB

  1. #1
    SitePoint Mentor NightStalker-DNS's Avatar
    Join Date
    Jul 2004
    Location
    Cape Town, South Africa
    Posts
    2,873
    Mentioned
    44 Post(s)
    Tagged
    0 Thread(s)

    Access DB

    Hey guys

    Have an access database and have an ID that auto incerments automatically. I know how to do this in SQL Server, but cnt seem to figure out how 2 do this in access.

    Any help would be much appreciated.

    Thanks

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    you mean, how to create a table with an autonumber column in access?

    in table design view, choose "autonumber" as the datatype

    if you are feeding DDL to access, use COUNTER as the datatype -- see http://support.microsoft.com/kb/q180841/
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •