Solved

Microsoft Works Database Error and possible conversion?

Posted on 2011-09-06
3
433 Views
Last Modified: 2012-05-12
Ok first off, my Microsoft Works database 2006 program is giving me out of memory errors when I try to pull up a report. I click ok on that error message and then it will let me view the report but I cannot print as I get the same out of memory errors and have to hit OK a couple of times to get them to go away. Any idea on how to fix this issue? File possibly corrupted as it happens on two computers.

Second, can I possibly take this .wdb file and convert it to excel or even access? Or anyway to import the information? There isn't a whole lot of info at all, a basic table and then 115 lines in the spreadsheet that the report pulls from.
0
Comment
Question by:ZephyrM
[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
3 Comments
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36491280
I don't know how to fix that error, but I believe Microsoft Works has the ability to export into a CSV file.  A CSV file can be opened in Excel.  If that doesn't work, here is a link a Works Database Converter.

http://www.codealchemists.com/worksdatabaseconverter/

Greg

0
 

Author Comment

by:ZephyrM
ID: 36491332
I actually ran that converter a bit ago and was able to import everything over into Access. Now just trying to get the reporting to display how we want it :)
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36491361

Is this a new issue?
If so, then what changed on the PC's that exibit this issue.

Check the *Available* memory in the task manager, and compare these values on the PCs that do not have this error and the ones that do.


If this is a Works DB, then you can save it as a CSV file(s).
You can then easily import these files into Access.

Quite a bit or work will have to go into it working the same as when it was in Works, but you will be now working with a higher level DB engine, and will have many more tools and functionality at your disposal.

;-)

JeffCoachman
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

717 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