By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,160 Members | 1,066 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,160 IT Pros & Developers. It's quick & easy.

Auto Number field and ReSet used only for export files

P: 31
Ok now everyone has mentioned not to use auto number if it means anything to the user. My application uses the auto number for exporting only. I append the mastertbl column with my starting number of 0001(4 digits) (prior to populating the table). When information is imported and appended via a query to the mastertbl it will start with 0002 and increment. All tables used are cleared with a delete query after being exported, this allows the number to continue to increment during the day if another file is imported and appended to the mastertbl. This is a single user environment.
I have set up an automatic compact and backup of the database each day at 11:00 PM which resets the auto number. Thanks to www.PetersSoftware.com MS Access utility.

Now the question: Does anyone see any problems that may occur with this process? Is there a better way to do this process??

I have attemted DMax and for my purpose and do not believe it will work for my application.
Dec 11 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
It sounds as if it will work OK. However, the nature of these things are that problems only appear when used. I would advise monitoring the incrementing number at key times for a few weeks to see if everything is OK.
Jan 8 '08 #2

P: 31
It sounds as if it will work OK. However, the nature of these things are that problems only appear when used. I would advise monitoring the incrementing number at key times for a few weeks to see if everything is OK.
I will keep on eye on it and thanks for the reply. I was hoping to reach a number and have it reset when it reaches the goal number. I could not figure that one out.
Jan 8 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I will keep on eye on it and thanks for the reply. I was hoping to reach a number and have it reset when it reaches the goal number. I could not figure that one out.
If you are using the number as the primary key this cannot be done. Also using an autonumber means all records would have to be removed and the the compact and repair run to reset to 0.
Jan 8 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.