ACCESS FEED: Re: [MS_AccessPros] Primary Key Field to re-start numbering from 1

Rabu, 30 Desember 2015

Re: [MS_AccessPros] Primary Key Field to re-start numbering from 1

Hi John,

Getting "Compile error: Expected: end of statement"

Regards,

James

On Wed, Dec 30, 2015 at 3:02 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

James-

Run a query like this:

ALTER TABLE MyTable ALTER COLUMN ID Counter(1, 1);

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Dec 30, 2015, at 12:56 PM, James Asante asanteza@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi
I have a table that is deleted and appended from time to time. The primary key has the following properties:

Field Name = ID
Data Type = AutoNumber
Field Size = Long Integer
New Values = Increment
Indexed = Yes (No Duplicates)
Text Align = General

Is there a way to get the ID to start at 1 when the table is cleared (deleted) and appended every time?

Thanks
James