Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Corrupt Database

Posted on 2009-05-16
10
Medium Priority
?
336 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 2000 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

721 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