|Subject:||Re: Pdox and access
|Date:||Tue, 21 Apr 2020 19:03:23 +1000
|From:||Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
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
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.