Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access courses - keys

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Keys

microsoft access courses - Keys

ResolvedVersion Standard

Jenny has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Keys

In a table can you combine two foreign key attributes to make a primary key without causes problems in the table. How do you do this

RE: Keys

You can make a primary key out of two fields.
Simply select BOTH fields in the design view and then click the Primary Key button.

This may or may not cause problems in your database, depending on how it is setup and layed out. Suggest backing up your database and testing it out first.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.