quincey33 
Posts:7
 |
| 09/11/2006 2:02 PM |
 Alert
|
I have an oddbvall questioin here. This is regarding old tax lists. e.g. I just updated Clements 2005 but I also have Clements 2004 etc. How can I remove them so as not to keep crowding up my space?
Regards,
Werner
.X |
|
|
|
|
jjones
Posts:5099
|
| 09/11/2006 2:44 PM |
Alert
|
Use the Tax Viewer window. Select the old tax list from the dropdown and then click the Delete button to the right.
Jeff |
|
Birder's Diary Technical Support |
|
|
quincey33
Posts:7
|
| 09/12/2006 1:33 PM |
Alert
|
Hi Jeff,
I';ve done that and followed the instructions to import the new Tax list using the instructions given in "Importing a new tax list".
But I'm getting the following message: Unexpected handling error
3022 - The changes you requested to the table were not successful because they whould create duplicate values in the index, primary, key.... etc.
What do I have to do to be able to import the list so I can regiser it?
Regards,
Werner
|
|
|
|
|
jjones
Posts:5099
|
| 09/12/2006 1:41 PM |
Alert
|
Posted By quincey33 on 09/12/2006 1:33 PM
Hi Jeff,
I';ve done that and followed the instructions to import the new Tax list using the instructions given in "Importing a new tax list".
But I'm getting the following message: Unexpected handling error
3022 - The changes you requested to the table were not successful because they whould create duplicate values in the index, primary, key.... etc.
What do I have to do to be able to import the list so I can regiser it?
Regards,
Werner
Hi Werner,
You can register/activate/license your tax list without importing it. So go ahead and do that at any time.
For this error (it sounds like database corruption), I am going to need to get your database. Please do the following:
1. ZIP your database (c:\program files\birders diary\data\database.mdb)
2. Upload it using the Support >> File Upload page on this web site.
Let me know if you need any assistance with this.
Jeff |
|
Birder's Diary Technical Support |
|
|
quincey33
Posts:7
|
| 09/12/2006 2:58 PM |
Alert
|
The database has been uploaded.
Regards,
Werner |
|
|
|
|
jjones
Posts:5099
|
| 09/12/2006 3:08 PM |
Alert
|
Hi Werner,
I do not see any file uploaded yet. Are you sure it completed?
Jeff |
|
Birder's Diary Technical Support |
|
|
jjones
Posts:5099
|
| 09/13/2006 8:22 AM |
Alert
|
Hi Werner,
You had the "AutoNumber" bug in your MSAccess database. I fixed it and emailed it back to you.
Please confirm that you received it.
When you get it:
1. Save the ZIP file to disk
2. Make a copy of your current datbase
3. Unzip the file
4. move the corrected database into your /data directory over your existing database
5. Start Clements import
Jeff |
|
Birder's Diary Technical Support |
|
|
SteveO
Posts:509
|
| 09/13/2006 8:30 AM |
Alert
|
Jeff,
Out of curiosity, if the "autonumber" bug occurs,
If the user restores a clean backup database copy, will the clean copy be contaminated?
If the bad database is deleted and a clean database backup is renamed, will that fix it?
Regards,
Steve |
|
Regards,
Steve |
|
|
jjones
Posts:5099
|
| 09/13/2006 8:34 AM |
Alert
|
Posted By SteveO on 09/13/2006 8:30 AM
Jeff,
Out of curiosity, if the "autonumber" bug occurs,
If the user restores a clean backup database copy, will the clean copy be contaminated?
If the bad database is deleted and a clean database backup is renamed, will that fix it?
Regards,
Steve
Hi Steve,
No and Yes. Best guesses.
However, I am not sure what causes it, but the problem may have to do with the MSaccess CompressAndRepair function that I do on each and every backup. I read some such thing on the Microsoft web site - but it is very vague.
Jeff |
|
Birder's Diary Technical Support |
|
|
quincey33
Posts:7
|
| 09/14/2006 7:03 AM |
Alert
|
Thanks The problem is solved now and I imported the Clements list ok.
One other question: On the bottom line I show my 3 choices of list. I use World, Tri-State and New York.
The World list stays "0" count while the other two are ok.
How can I get the world count to be what it is supposed to be, i.e. my world life list count instead of "0"?
Regards,
Werner
|
|
|
|
|
jjones
Posts:5099
|
| 09/14/2006 7:31 AM |
Alert
|
HI Werner,
You need to Edit your observer and change the tax list to your new Clements list. It is still pointing to your old Clements list.
1. Click on the Observers toolbar button
2. Select your observer and click on the Edit button
3. Change your tax list appropriately
Jeff |
|
Birder's Diary Technical Support |
|
|
Bert Frenz
Posts:119
|
| 09/23/2006 6:04 AM |
Alert
|
| I also got RTE 3022 when importing the world location csv. I read this tread and I don't see how the problem was resolved. |
|
|
|
|
jjones
Posts:5099
|
| 09/23/2006 9:11 AM |
Alert
|
Posted By Bert Frenz on 09/23/2006 6:04 AM
I also got RTE 3022 when importing the world location csv. I read this tread and I don't see how the problem was resolved.
Hi Bert,
You probably have the autonumber bug in MSaccess as well. The only way I know of to fix it is for you to upload your database (backup, then zip) via the file upload page on this site.
I will fix it and return it to you.
Jeff |
|
Birder's Diary Technical Support |
|
|