Apple Works Data Base Replacement

I've tried that, Base doesn't seem to be able to do much with AW files.

Allan Jones wrote:

LibreOffice has a database component that is compatible with MS Access. Download it (it's free) and see if its program called "Base" will open the AW files. It works for WP files but it won't cost you anything to test it with the DB files.

http://www.libreoffice.org/discover/libreoffice/

There are only two solutions to Appleworks databases:

1) Continue to run AW in Snow Leopard natively when possible, and in virtualization, such as Parallels otherwise; and/or

2) When running AW, export the database data, build a new database in another program such as Filemaker and import the data from AW and abandon AW.

Will regular Snow Leopard (available for 19.99) work in parallels? or does it have to be the server version?

I am just trying to make it available for the least expense and still have access to my current programs. AW data was easy to use and had the options we needed. While I can find FileMaker pro 10 for $120, I thought I had read it had a steep learning curve. While I did DataStar on a CPM card in an AppleII, I'm afraid I would have to dig down pretty deep to FMP up and going.

My office computer runs Lion (10.7.5) and I have an earlier version of Parallels that might be upgradable. Snow Leopard Server is available for around $75 to 85. So in the end it might be slightly more expensive to do the Parallels route.

If I didn't need my current programs when running AW data in Snow Leopard, I can just boot on my SL drive.

So in the end, it comes down to convenience, vs money and time leaning FMP, verses more money and time installing SLS in Parallels.

Thanks for the links that show how to install SLS in Parallels.

James Mol wrote:

Will regular Snow Leopard (available for 19.99) work in parallels? or does it have to be the server version?

The first link will show how to install Snow Leopard client; the 2nd link, Snow Leopard Server.

However, with SLS now the same price as Snow Leopard client, I always recommend you use SLS, which is easier to install, run and maintain.

To get SLS for $20, you must call Apple 1.800.MYAPPLE (1.800.692.7753) - and tell them you want Apple Part Number: MC588Z/A. If you run into resistance, ask to speak to another representative.

James Mol wrote:

While I did DataStar on a CPM card in an AppleII, I'm afraid I would have to dig down pretty deep to FMP up and going.

I still run CP/M on my Apple //c with its Z-RAM card! 🙂

Dropping my database into numbers worked. However, the Find function does not do what the Appleworks program did. Any suggestions?

How did you "drop" the database into numbers? I'm having problems visualizing what you did. And what version of Numbers are you using & what version of AppleWorks created the database?

When I moved my AppleWorks 6 databases to Numbers several years ago I found two ways to get useable files. In AppleWorks, switch to List View, select all, and then copy & paste into a Numbers table. You can also paste the data into an AppleWorks spreadsheet & save that to be opened by Numbers. I like the first method as it would retain font formatting (bold, italics, etc.) although nothing else.

Once the data is in Numbers you can use Find to find a specific person or thing & you can sort but you don't have the nice looking reports that AppleWorks' database gave you. Calculations are gone & will have to be re-created. The calculation part is pretty simple usually, after all, Numbers is a spreadsheet. The reports are a bit more challenging. Look at the VLookup and HLookup formulas — they should be helpful. Look through the Numbers templates for ideas, too.