If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot name an Access Table
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??? |
#2
|
|||
|
|||
Cannot name an Access Table
Select the table in the database window and right-click it. Select "Rename"
from the pop-up menu options. -- Duane Hookom MS Access MVP -- "ADM_Dover" wrote in message ... 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??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |