asked on

Corrupt Database

A friend on mine is using QuickSell 2000 ver. 3.01. The system (win 2000 server) crashed was repair/reinstalled. Since then the POS workstation works ok but the Manager generates errors when changes are made and it does not apply the changes. The following error is generated when applying any changes:

Error 3315: Field 'Register.PaperCutterCodes' can't be a zero-length string.

I have tried reparing and compacting the database from the QuickSell Manager and also MS-Access but the error still remains.

Please Help.

ASKER CERTIFIED SOLUTION

tbsgadi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bassgurru

ASKER

Thanks Gary for responding. I can open the database using MS Access 2003, but because it's an old program the database has to be converted first. I don't know whether this helps or makes matters worse. I get a similar error for each field in the configuration section of the manager that were normaly left blank, also in the table register it is set to allow Zero-length field. I am still struggling.

tbsgadi

It's a 2000 mdb?
Do you have access to a PC with Access 2000?

Bassgurru

ASKER

The QuickSell 2000 mdb is compatible with Access 97.

i am trying to get a copy of Access 97... it's a bit hard to find. When i use Access 2000 it converts the format to Access 2000. I don't think Quicksell will accept this format.

tbsgadi

You might need to find Access 97.
Is there any way of opening in 2000 without converting?

Bassgurru

ASKER

It won't open in access 2000 without converting first.

Iwill order the Access 97. saw it on Amazon.com.

I will let you know how it goes.

Thanks for you assistance.

Bassgurru

ASKER

Hey Gary,
Thanks for this great tip of opening the Table register and editing the fields. I used the design view to changes the "Allow Zero-length String" from no to yes for all the fields that were being reported as can't be Zero length. Worked great.

Thanks a million.

tbsgadi

Great! Glad to help!

tbsgadi

"Thanks for this great tip " "Thanks a million."
I helped you arrive at your solution, so you shouldn't close the question but accept one of the answers