A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cannot name an Access Table



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2006, 06:44 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old January 19th, 2006, 07:57 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.