Cannot name an Access Table

A

ADM_Dover

One of our teachers is trying to create tables in an Access database. When
they design the table and have every field as a text field, the user is able
to give the table a name. However, when other field types are added, such as
Yes/No, currency, etc., and then when closing the table and asking to give it
a name, a name is typed in, but a message keeps apeparing asking for a
primary key. User clicks NO, names table, but the table does not name and is
not able to be saved???
 
D

Duane Hookom

Select the table in the database window and right-click it. Select "Rename"
from the pop-up menu options.
 

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