Page 1 of 2 12 LastLast
Results 1 to 16 of 21

Thread: Access Grrrrrr!

  1. #1
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts

    Access Grrrrrr!

    Have decided Micros**t help is about as much use as a chocolate tea pot.

    How do you assign multiple keys in tables?

    The 'help' thing tells me all about the intricacies of keys etcetera, but leaves out one vital part HOW DO I DO IT!!!

    Any help gratefully received

    (smiling thorugh clenched teeth)

  2. #2
    Drop it like it's hot Howard's Avatar
    Join Date
    Jul 2003
    Location
    Surrey, South East
    Posts
    11,731
    Thanks
    14
    Thanked
    42 times in 39 posts
    • Howard's system
      • Motherboard:
      • Asus P5B
      • CPU:
      • Core2Duo E6420 2.13GHz
      • Memory:
      • 2x1gb OCZ DDR2 6400
      • Storage:
      • 250GB & 500GB Seagate
      • Graphics card(s):
      • Inno3d iChill 7900GS
      • PSU:
      • Antec SmartPower 500W
      • Case:
      • Coolermaster Elite 330
      • Monitor(s):
      • 2x AG Neovo F419
      • Internet:
      • Virgin Media 20mbit
    You can't AFAIK.
    Home cinema: Toshiba 42XV555DB Full HD LCD | Onkyo TX-SR705 | NAD C352 | Monitor Audio Bronze B2 | Monitor Audio Bronze C | Monitor Audio Bronze BFX | Yamaha NSC120 | BK Monolith sub | Toshiba HD-EP35 HD-DVD | Samsung BD-P1400 BluRay Player | Pioneer DV-575 | Squeezebox3 | Virgin Media V+ Box
    PC: Asus P5B | Core2duo 2.13GHz | 2GB DDR2 PC6400 | Inno3d iChill 7900GS | Auzentech X-Plosion 7.1 | 250GB | 500GB | NEC DVDRW | Dual AG Neovo 19"
    HTPC: | Core2Duo E6420 2.13GHz | 2GB DDR2 | 250GBx2 | Radeon X1300 | Terratec Aureon 7.1 | Windows MCE 2005
    Laptop: 1.5GHz Centrino | 512MB | 60GB | 15" Wide TFT | Wifi | DVDRW


  3. #3
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    AFAIK??

  4. #4
    Kirstie Allsopp Theo's Avatar
    Join Date
    Jul 2003
    Location
    Sunny Bolton
    Posts
    2,777
    Thanks
    17
    Thanked
    23 times in 20 posts
    • Theo's system
      • Motherboard:
      • Asus P5B Wifi deluxe
      • CPU:
      • E6600 @ 3150Mhz
      • Memory:
      • 2x2GB OCZ 6400
      • Storage:
      • 1x80GB Maxtor
      • Graphics card(s):
      • 640MB 8800GT
      • Monitor(s):
      • ASUS M221u
      • Internet:
      • Be Value
    As Far As I Know

  5. #5
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    Cheers.

    I'd imagine that it was possible, as the help explains all about it.

    I've also managed it in MySQL.

  6. #6
    Drop it like it's hot Howard's Avatar
    Join Date
    Jul 2003
    Location
    Surrey, South East
    Posts
    11,731
    Thanks
    14
    Thanked
    42 times in 39 posts
    • Howard's system
      • Motherboard:
      • Asus P5B
      • CPU:
      • Core2Duo E6420 2.13GHz
      • Memory:
      • 2x1gb OCZ DDR2 6400
      • Storage:
      • 250GB & 500GB Seagate
      • Graphics card(s):
      • Inno3d iChill 7900GS
      • PSU:
      • Antec SmartPower 500W
      • Case:
      • Coolermaster Elite 330
      • Monitor(s):
      • 2x AG Neovo F419
      • Internet:
      • Virgin Media 20mbit
    Sorry. I use too many acronyms. Lol.

    My ICT teacher swears that you can't have two primary keys, and he usually knows what he's talking about.
    Home cinema: Toshiba 42XV555DB Full HD LCD | Onkyo TX-SR705 | NAD C352 | Monitor Audio Bronze B2 | Monitor Audio Bronze C | Monitor Audio Bronze BFX | Yamaha NSC120 | BK Monolith sub | Toshiba HD-EP35 HD-DVD | Samsung BD-P1400 BluRay Player | Pioneer DV-575 | Squeezebox3 | Virgin Media V+ Box
    PC: Asus P5B | Core2duo 2.13GHz | 2GB DDR2 PC6400 | Inno3d iChill 7900GS | Auzentech X-Plosion 7.1 | 250GB | 500GB | NEC DVDRW | Dual AG Neovo 19"
    HTPC: | Core2Duo E6420 2.13GHz | 2GB DDR2 | 250GBx2 | Radeon X1300 | Terratec Aureon 7.1 | Windows MCE 2005
    Laptop: 1.5GHz Centrino | 512MB | 60GB | 15" Wide TFT | Wifi | DVDRW


  7. #7
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    you can't have two primary keys...

    But...

    Each table has one and only one primary key, which can consist of one or many columns. A concatenated primary key comprises two or more columns. In a single table, you might find several columns, or groups of columns, that might serve as a primary key and are called candidate keys. A table can have more than one candidate key, but only one candidate key can become the primary key for that table.
    http://www.sqlmag.com/Articles/Index...leID=5113&pg=1

  8. #8
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    Access is too primative to support this I believe. MS SQL Server and others can do it however.
    Simon


  9. #9
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    Cheers Shad



    Will have to set up an autonumber key

  10. #10
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    Can't have multiple primary keys. Can have a composite primary key....
    Now go away before I taunt you a second time.

  11. #11
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    Any idea how to do that Rythmic?

  12. #12
    Member
    Join Date
    Aug 2003
    Location
    Wimbledon
    Posts
    141
    Thanks
    0
    Thanked
    0 times in 0 posts
    In table designer hold down ctrl and then click in the leftmost column (the record selector) to highlight the fields you want to be part of your key. Whilst keeping ctrl pressed right click over your selection and select 'Primary key'.

    If you don't keep ctrl pressed when you right click it will only use the field the mouse is currently over.

  13. #13
    only the finest beef
    Join Date
    Nov 2003
    Posts
    1,175
    Thanks
    4
    Thanked
    0 times in 0 posts
    Cheers Mart,

    I was releasing Ctrl before i right clicked.

    Hexus Forums - the source for infinite knowledge

  14. #14
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    Bizaar how Access requires that, but SQL Enterprise manager doesn't...
    Now go away before I taunt you a second time.

  15. #15
    Senior Member
    Join Date
    Sep 2003
    Location
    Guernsey, channel rocks
    Posts
    247
    Thanks
    0
    Thanked
    0 times in 0 posts
    I used Access as part of my AVCE ICT course, I hated it with a passion.

  16. #16
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    TBH - it's a pain in the arse if you're used to more upmarket dbs. But if compare it with other consumer level stuff, it's not bad.

    Yes I know MySQL is free, but it's not something that Joe bloggs will understand. I'd rather use MySQL myself (if oracle or ms sql is not available.
    Now go away before I taunt you a second time.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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