Reset Autonumber values in Access DB

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
engla001 Members Profile Find Members Posts Newbie Joined: 25 January 2004 Location: United States Status: Offline Points: 22	Post Options Post Reply Quote engla001 Report Post Thanks(0) Quote Reply Posted: 04 February 2004 at 11:37pm
	If you will run the Compact and Repair Database tool AFTER you have dumped everything from the database it will reset the Autonumbering. However, if you do not dump all user accounts - including the admin accounts - the autonumber will reset in all tables except tblAuthor. Edited by engla001

Phat Members Profile Find Members Posts Senior Member Joined: 23 February 2003 Status: Offline Points: 386	Post Options Post Reply Quote Phat Report Post Thanks(0) Quote Reply Posted: 05 February 2004 at 1:13am
	If you're making a whole new database just make a blank db then use the import tool to import the structre from the other database. Just make sure you only import the structue and not the data. File > Get External Data > Import > Seelct you database Now Click the options button there is an optionin there for definition and data or just definition

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.