Subject: | Re: Pdox and access
| Date: | Mon, 20 Apr 2020 18:29:34 +1000
| From: | Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
| Newsgroups: | pnews.paradox-development
|
The Jet engine is deprecated and no longer supported. If it's a newer
version of Access it's probably using a lite version of SQL server.
However, in either case, as Anders said, you can use MS' access ODBC
driver for Access tables. You'll need to know the structure and
sometimes there are problems. An Access database is a single .mdb file
and corruptions occur really easily. Doing a series of writes in the
wrong order will hose your database. I once was involved in supporting a
POS system written in Access, linking to ERP software written in Visual
Basic and SQL Server databases. It was an absolute nightmare, the Access
databases were as fragile as Murano glass.
From Access, you can easily access Paradox tables using the Paradox
ODBC driver.
On 20/04/2020 4:49 pm, modridirkac wrote:
> A customer of mine has my application in P9.
> He also has some forms in access, which he also uses.
>
> Now, he wants to talk about accessing data both way.
> What are my options?
> Which Access versions are "supported"?
> I have not used Access before, but I assume I can access MDB file over
> ODBC?
>
> Thx, Jure
|