Solved

Corrupt Database

Posted on 2009-05-16
10
327 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 

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
 
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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
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…

759 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