Paradox Community

Items in pnews.paradox-development

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


Copyright © 2004 thedbcommunity.com