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.  
BassgurruAsked:
Who is Participating?
 
tbsgadiConnect With a Mentor Commented:
Can you open the Database?
If so have a look in Table Register to see whether the field PaperCutterCodes has any blank values. If so try enetering a value.

Hope this helps

Gary
0
 
BassgurruAuthor Commented:
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.
0
 
tbsgadiCommented:
It's a 2000 mdb?
Do you have access to a PC with Access 2000?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
BassgurruAuthor Commented:
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.
0
 
tbsgadiCommented:
You might need to find Access 97.
Is there any way of opening in 2000 without converting?
0
 
BassgurruAuthor Commented:
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.
0
 
BassgurruAuthor Commented:
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.
0
 
tbsgadiCommented:
Great! Glad to help!
0
 
tbsgadiCommented:
"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
0
All Courses

From novice to tech pro — start learning today.