Paradox Community

Items in pnews.paradox-development

Subject:Re: Pdox and access
Date:Tue, 21 Apr 2020 19:03:23 +1000
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-development
On 21/04/2020 5:07 pm, modridirkac wrote:
> I would only READ data from other application.
> Access would only READ data from my application.
> 
> Would that (only reading) be safer?

You would still be  putting a read lock on Paradox tables from an 
external program. The same would apply to Access tables. Access has only 
page locks, not record locks, so your read locks on a whole page could 
break it.

My only suggestion is to try it and see, after warning your user it's a 
bad idea and it could cause intermittent problems that require 
rebuilding an reorganising tables and/or access databases. Who knows? 
Depending on the workflows and traffic, you may have no problems at all.

In the best of all worlds, you would combine both databases in a SQL 
Server database and have Paradox and Access use the same database. No 
problem at all.

As Steven said, it's a bad idea.


Copyright © 2004 thedbcommunity.com