Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

How do i lengthen the primary key in microsoft access

Sent to Computer Experts September 9 2006 at 8:55 AM
   

Im trying to setup a music database on access. I want the Artist as a primary key, but it will only allow me 4 characters, is there an option to change this? Cheers

Customer (name blocked for privacy)
Status:  Closed   Value: $8
Answer
September 9 2006 at 9:02 AM (6 minutes and 56 seconds later)
         
ACCEPTEDCheck Mark

This should be fairly easy to do. In the Table that you have, go to the Properties and in the General tab, you have to change the Field Size to increase the length of your field.Refer

http://www.bcschools.net/staff/AccessHelp.htm

http://www.shsu.edu/administrative/training/guides/pdfs/access_tables.pdf#search=%22Change%20Size%20primary%20key%20in%20Microsoft%20Access%22

Pls. let me know if anything is unclear.



Edited by harishmathur on September 9 2006 at 9:04 AM
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer Questions