Robin
Robin at rolledgold.net
Wed May 10 12:09:31 CDT 2006
Thanks Gustav, Reading the 'Alter Table' section seem to agree with you - then I saw this ? 'As a side note (and in addition) to changing field data types or changing the seed and increment value of an Auto-increment data type, the programmer can also drop fields and constraints. ' But I can't decipher the syntax to see how it can be done... Rgds Robin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 10 May 2006 18:08 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Resetting Autonumber seed Hi Robin It doesn't look so: http://support.microsoft.com/kb/q275561/ This article describes the new features of Microsoft Jet 4.0, and the article also compares some of the changes between Microsoft Jet 3.5 and Jet 4.0. /gustav >>> Robin at rolledgold.net 10-05-2006 18:37:10 >>> Thanks Marty - The line wrap is just in Outlook - viewing strsql gives the intended line ... Does anyone know if the syntax is valid - checking help in Access 97 doesn't give the "counter" option Rgds Robin -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com