Access Grrrrrr!

**Angus** · 28-12-2003, 05:36 PM

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)

**Howard** · 28-12-2003, 05:50 PM

You can't AFAIK.

**Angus** · 28-12-2003, 05:51 PM

AFAIK??

**Theo** · 28-12-2003, 05:56 PM

As Far As I Know

**Angus** · 28-12-2003, 05:59 PM

Cheers.

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

I've also managed it in MySQL.

**Howard** · 28-12-2003, 06:27 PM

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.

**Angus** · 28-12-2003, 06:34 PM

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

**Shad** · 28-12-2003, 07:03 PM

Access is too primative to support this I believe. MS SQL Server and others can do it however.

**Angus** · 28-12-2003, 07:05 PM

Cheers Shad

Will have to set up an autonumber key

**Rythmic** · 28-12-2003, 09:19 PM

Can't have multiple primary keys. Can have a composite primary key....

**Angus** · 28-12-2003, 10:49 PM

Any idea how to do that Rythmic?

**Mart** · 28-12-2003, 11:56 PM

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.

**Angus** · 29-12-2003, 12:00 AM

Cheers Mart,

I was releasing Ctrl before i right clicked.

Hexus Forums - the source for infinite knowledge

**Rythmic** · 29-12-2003, 11:55 AM

Bizaar how Access requires that, but SQL Enterprise manager doesn't...

**DaftpuNk** · 29-12-2003, 03:14 PM

I used Access as part of my AVCE ICT course, I hated it with a passion.

**Rythmic** · 29-12-2003, 06:01 PM

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.

Thread: Access Grrrrrr!

LinkBack

Thread Tools

Access Grrrrrr!

Thread Information

Users Browsing this Thread

Posting Permissions