471,579 Members | 1,885 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,579 software developers and data experts.

MS Access as front-end for Paradox database?

I've got an old DOS Paradox database that I can't get rid of. We have
way to many scripts and forms to convert everything at once. Instead
we would like to be able to access the Paradox data from MS Access, so
that we can create a few select forms using Access.

I've been trying for a while to get MS Access to work correctly with a
linked Paradox table. It works fine for reading, but when I attempt to
edit records in Access, especially if another user is working with the
same table in Paradox at the same time, I end up with data corruption.
I've read all of the articles and tried all of the fixes, including
getting the latest versions of the BDE and all of the MS Access and
MDAC updates, but no luck.

Has anyone done something like this, or faced a similar problem? I
also looked at the newer version of Paradox, which works fine
side-by-side with the old version, but it is not anywhere as nice as
Access (I actually prefer the old DOS version over the new Windows
version of Paradox).

Would adding a SQL server as a middle-man between Paradox and MS Access
help? Can a SQL server serve Paradox tables without the corruption
issues I'm having with MS Access?

I know the BDE is able to work with my Paradox data, without causing
data corruption, because I can write a program using BDE components
(VCL, Delphi, C++) that work with the data. However, I'd rather use a
database program like MS Access, which already has all of the nice
query building and report functions, as it would take much less time
than creating an application in Delphi, C++, Visual Basic, etc.

Feb 17 '06 #1
0 1712

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Jo | last post: by
2 posts views Thread by Berae | last post: by
2 posts views Thread by Johnny Meredith | last post: by
1 post views Thread by =?Utf-8?B?VGlnZXJtYW4=?= | last post: by
6 posts views Thread by Adam Donahue | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.