Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Validate Error: No table is open in current work area (Open Window appears after clicking Validate)

If you click on the Validate Records button and that produces an Open window looking for a .dbf file and canceling that window results in this error,
form1.addcolumns line 177
error 52
no table is open in current work area


This could mean you have a damaged or corrupted field.dbf and field.fpt files.

Exit AccuZIP6 and download http://www.accuzip.com/files/forum/fields.zip and extract it into the C:\Program Files\AccuZIP6 5.0\Support folder, replacing the existing files of the same name.

This could also mean you're importing a .dbf file into AccuZIP6 that contains a Numeric type field, and that Numeric type field has a width of over 20 characters. The AccuZIP6 database can have a numeric field be up to 20 characters, so to quickly remedy the issue, pull down the Edit menu to Fields and change the width to 20 or less. Click OK and click Yes, and you'll be able to validate again.

If you have a Numeric type field with over 20 characters and you try to export, you'll get an Illegal Field Length error when attempting to export.

You will also get this error if you have a Company, Address, Address2, City, St or Zip field with a length of 0.

« Back to Tech Notes

I am especially motivated to take time to draw attention to Vince. In two instances, we potentially faced loss of product – significant loss, but thanks to everyone’s efforts, most notably Vince’s, we ended up with minor re-work and zero loss of stock. He’s patient and thorough, knowledgeable and resourceful. And he’s patient – A Big Plus when dealing with me. Long story short, the guy was able to not only produce a solution, but to prove to me the veracity of it. I hung up the phone saving thousands of dollars in catalog stock, not lost but salvaged, and my department had to spend just a wee bit of time on job re-work (which I was happy to do, all things considered). But I also hung up with a peculiar urge to write about Vince, incongruent as that may be since I rarely am moved to write letters of this sort. So… In a time of crisis, Vince was a terrific asset and ally. If I were his boss, I’d attempt a merit raise authorization, he was that exceptional.
H.D., Shawnee Mission, KS