Solved

Corrupt Database

Posted on 2009-05-16
10
313 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
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…

776 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