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

Read/write to Paradox files

Hello, Experts:

A client has an app that uses Paradox files to handle customers, accounts, and lab results.  Now he'd like a website to publish the results of tests and to take orders, etc.

What is the best way to access these tables?  That is, can I just import these items to VS controls?

Is there any freeware to do this?  Do I need a copy of the Paradox database?  (Who services Paradox these days anyway?)

Any help and direction is greatly appreciated.

Capt
0
Glen Gibb
Asked:
Glen Gibb
  • 3
  • 3
1 Solution
 
Bill BachPresidentCommented:
Do you have the Paradox ODBC driver installed?  If so, then the easiest way to do this is via direct ODBC access from a web page, from ASP, ASP.Net, or the like.
0
 
Glen GibbOwnerAuthor Commented:
Can you tell me more about installing the Paradox ODBC driver?
0
 
Bill BachPresidentCommented:
I expect that it would have come with the Paradox software.  Here's some info about setting it up:
    http://www.thedbcommunity.com/index.php?option=com_content&task=view&id=70&Itemid=46
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Glen GibbOwnerAuthor Commented:
Perfect!  The link allowed me to successfully import the table into Access!

Has this import given me access to the original Paradox table in its directory, or have I created a separate copy that will not be updated if I change it in an Access DB?
0
 
Bill BachPresidentCommented:
If you selected "import" in Access, then you should have your own copy of the data.
If you selected "link", then you are accessing live data. The icon for a link is an arrow and globe.

If you are unsure, change one value in the app and see if it changes in Access.
0
 
Glen GibbOwnerAuthor Commented:
Wonderful!  Didn't even see the "Link" button.  Works like a charm.  Thanks for all your help.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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