Re: Problem with Order# or customer #

[ Follow Ups ] [ Post Followup ] [ Order Desk Pro Support ] [ FAQ ]

Posted by Sue Sloan on March 31, 2004 at 07:37:29:

In Reply to: Problem with Order# or customer # posted by tim compagna on March 30, 2004 at 15:51:34:

: Suddenly out of nowhere, my custmer# does not auto complete when I add a new record. Also when I add a new order, no order number is given. I have no idea what could have happened. It has worked fine for the past 5 years. Please help ASAP. :0

This will happen if you delete the .ADX type files for your databases. The next number for customer and order number is stored in those files. It can also happen if you have corrupted database indexes and you find a file of type .OYZ in the folder where your databases are stored.

If there is no .OYZ file, just go into Field Definition and reset the next numbers to the highest customer and order number plus 1.

In general, you should never delete the .ADX files. The .ADX and .DBF files are a "set". Some databases also have a .DBT file to hold the memo-type fields, like the "comments" in customer and order data.

If you have an .OYZ file, you will need to locate a good backup of your database files. Then delete both the .ADX and .OYZ of the same name. Copy just the .ADX file from the backup into the folder. Then reset the next serial number using Field Definition.

Sue Sloan

Follow Ups:

Post a Followup

Name    : 
E-Mail  : 
Subject : 

Comments:
: : Suddenly out of nowhere, my custmer# does not auto complete when I add a new record. Also when I add a new order, no order number is given. I have no idea what could have happened. It has worked fine for the past 5 years. Please help ASAP. :0

: This will happen if you delete the .ADX type files for your databases. The next number for customer and order number is stored in those files. It can also happen if you have corrupted database indexes and you find a file of type .OYZ in the folder where your databases are stored. 

: If there is no .OYZ file, just go into Field Definition and reset the next numbers to the highest customer and order number plus 1.

: In general, you should never delete the .ADX files. The .ADX and .DBF files are a "set". Some databases also have a .DBT file to hold the memo-type fields, like the "comments" in customer and order data. 

: If you have an .OYZ file, you will need to locate a good backup of your database files. Then delete both the .ADX and .OYZ of the same name. Copy just the .ADX file from the backup into the folder. Then reset the next serial number using Field Definition.

: Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL:

[ Follow Ups ] [ Post Followup ] [ Order Desk Pro Support ] [ FAQ ]