• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

Paradox to Access Conversion Project

Hey Experts!

I have been given the job of converting a huge and very complicated Paradox application to Microsoft Access. I have successfully migrated most of the tables (which will eventually wind up in SQL) but have no experience with Paradox -- nor can I seem to find any "tools" to use to get  into development mode of the forms, reports, etc.

Am I out of luck? Do I need to rebuild this entire thing from scratch?

Any direction, help, advise would be welcome.

Thanks, Eileen
0
Eileen Murphy
Asked:
Eileen Murphy
  • 4
  • 3
  • 2
  • +1
3 Solutions
 
Gustav BrockCIOCommented:
> Do I need to rebuild this entire thing from scratch?

Yes, you will need that.

If you can locate an old copy of Novell/Corel WordPerfect Office Professional or even Paradox itself and have a Windows 2000/XP machine to install on, you may be able to study the behaviour of the forms and reports, but that's all.

/gustav
0
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Maybe someone reading this will have access to these obsolete tools..... UGH!
0
 
Gustav BrockCIOCommented:
Or you can search on eBay for:

wordperfect office Paradox

Version 8 comes quite cheap.

/gustav
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
aikimarkCommented:
Do you know in what version of Paradox these tables were saved?
Do you need to do the import once or on an on-going basis?
0
 
aikimarkCommented:
For about $30, you can get a stand-alone Paradox converter:
http://www.dbf2002.com/paradox-converter/

If you have Delphi, you should be able to glom the Paradox data quite easily with the native drivers or add TSMImportFromParadox control from Scalabrium software.
http://www.scalabium.com/smi/

If the data isn't sensitive, you might be able to pay someone to do the conversion for you.
0
 
aikimarkCommented:
If you don't mind going through Excel, you can use this $20 utility from sobolsoft
http://www.sobolsoft.com/excelimportparadox/

Note: Sobolsoft also has an Access importer for Paradox data.
0
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
I don't need to convert the tables -- that's already been done. What I need it to get access to the queries, forms and reports -- and most importantly the code/functions.
0
 
aikimarkCommented:
Then you need to get a copy of Paradox.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Eileen,

<<Am I out of luck? Do I need to rebuild this entire thing from scratch? >>

I'm afraid so as gustav mentioned in the first comment.

There are no Paradox to Access converters that I'm aware of and like he, I've been using Access for a very long time.

And note this is not unusual.  While it's typically easy (relatively) to move data between different products, coding, forms, and reports are not.

Jim.
0
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Thanks all.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now