Solved

Corrupt Database

Posted on 2009-05-16
10
303 Views
Last Modified: 2012-05-07
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.  
0
Comment
Question by:Bassgurru
  • 5
  • 4
10 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24405176
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
 

Author Comment

by:Bassgurru
ID: 24460171
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
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24460629
It's a 2000 mdb?
Do you have access to a PC with Access 2000?
0
 

Author Comment

by:Bassgurru
ID: 24483114
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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 46

Expert Comment

by:tbsgadi
ID: 24490114
You might need to find Access 97.
Is there any way of opening in 2000 without converting?
0
 

Author Comment

by:Bassgurru
ID: 24507223
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
 

Author Comment

by:Bassgurru
ID: 24569813
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
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24569818
Great! Glad to help!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24569855
"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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
Read about achieving the basic levels of HRIS security in the workplace.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now