I can't get a simple database to work in Access 2007

M

MOS was 71331

I'm unable to convert an Excel table listing my recorded books into a simple
Access database.

The Access database would have three tables: Authors, Media, and Titles.

The Authors table would have two fields, ID and AuthorName, with ID being
its key. There are about 180 author records.
The Media table would have two fields, ID and Medium, with ID being its key.
There are 2 records: "CD Rom" and "Tape cassette".

The Titles table would have four fields: ID, Title, AuthorID, and MediumID.
AuthorID would be the ID in the Authors table for the book's author.
MediumID would be the ID in the Media table for the medium on which the book
is recorded.

The Authors and Media tables look as I expect.

When I tried to create the Titles table and have the AuthorID link to the
Authors table, Access says "The table must be saved before relationships can
be created. Save now?" When I answer "yes", Access says "The table could
not be saved."

I can't get past this point.

What am I doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top