Subject: | Re: Pdox and access
| Date: | Tue, 28 Apr 2020 09:32:12 +0200
| From: | Anders Jonsson <andersREMOVETHIS@jonssondata.se>
| Newsgroups: | pnews.paradox-development
|
I agree.
I would:
Install MS SQL Express. It's free and can be installed on almost any
Windows PC.
Then make routines in both the Access and Paradox apps that "copies" the
data needed to the SQL server.
From there on you can use whatever you like for reporting/reading data.
This could be a first step to migrate to an SQL server. Long term that
will give you better possibilities for future developlment.
Anders
Den 2020-04-21 kl. 01:58, skrev Kevin Zawicki:
> Risky and unstable.
> Having one access the others native data is problematic.
>
> You would be better off porting the data to SQL and using Paradox and MS-Access
> as frontends reworked to handle proper SQL.
>
> Or create exports and imports to send data into each other.
>
> Or or take apart the forms an code from one and convert to other, unify them
> on one tool.
>
>
>
>
> modridirkac <jure.zorko@gmail.com> 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
>
|