Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
Microsoft Access Developer Interview Question:
Explain me how do I make an autonumber field start from 1 again?
Submitted by: MuhammadWhen you are doing initial testing or if you make mistakes entering data and delete a row, the AutoNumber field keeps incrementing from the last number used. You may wish to start from 1 again (perhaps with existing data or perhaps after deleting initial test data).
This is very simply done as follows:
☛ Make a copy of the table (just in case)
☛ Remove all relationships between this table and any others
☛ If the AutoNumber field is a primary key, click on the primary key icon to undesignate it as a key
☛ Delete the row for this field
☛ Insert the row again and recreate the field as an AutoNumber field
☛ Redesignate it as a primary key, if appropriate
☛ Look at the table in design view - it should now be renumbering from 1 again.
☛ Reinstate the table relationships.
Submitted by: Muhammad
This is very simply done as follows:
☛ Make a copy of the table (just in case)
☛ Remove all relationships between this table and any others
☛ If the AutoNumber field is a primary key, click on the primary key icon to undesignate it as a key
☛ Delete the row for this field
☛ Insert the row again and recreate the field as an AutoNumber field
☛ Redesignate it as a primary key, if appropriate
☛ Look at the table in design view - it should now be renumbering from 1 again.
☛ Reinstate the table relationships.
Submitted by: Muhammad
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.