Paradox Community

Items in pnews.paradox-3rdparty

Subject:Re: Opening MS Access files in Paradox 11
Date:27 Sep 2019 06:13:48 -0400
From:"Andy" <>

Hi Liz

Can you take me through this step by step?  (I presume it's the 64-bit, not
the 32-bit, version I need to use.)


Liz McGuire <> wrote:
>You can't open an MDB directly.  You need to create an ODBC Data Source

>(look in Administrative Tools for the ODBC shortcut) to the MDB file, 
>then create a Paradox/BDE alias pointing to that ODBC Data Source.
>On 16 Jul 2017 19:32, Andy wrote:
>> Hi Steven, I've only ever used Paradox; no experience whatsoever in MS
>>  (I do have some experience with MS Word and Excel).
>> I probably need to read from the Access file roughly once a week.  I can't
>> export from the file as I'd need MS Access on my laptop to do that, and
>> don't have Access.
>> I've created an alias called "Other" using the path to the .mdb file but
>> when I attempt to open that folder I get the obscure error message I described.
>> What I'd like to be able to do is open .mdb files directly in Paradox
>> I can query, edit, format them, etc.  Is that possible and, if so, what
>> system files do I need?
>> All help is gratefully appreciated.
>> Many thanks,
>> Andy
>> Sydney Australia
>> ----------------
>> "Steven Green" <> wrote:
>>> are you a paradox guy, or an access guy? might make a difference in how
>> we
>>> explain and suggest..
>>> is this a one-time thing? might be simpler to export the data from access,
>>> to csv, then import the csv in paradox
>>> an alias is a substitute name for a path.. "work", for example, is the
>>> default working directory.. the actual path can be changed, for many
>>> reasons, but it's still your "work" directory, and you can refer to it
>>> such, instead of changing all the references to it in your code
>>> --
>>> Steven Green
>>> Myrtle Beach, South Carolina, USA
>>> Collectibles and Memorabilia
>>> Vintage Lego Sets and Parts
>>> - and Paradox support, too
>>> "Andy"  wrote in message news:594f08d4$
>>> I'm using Paradox on a computer running Windows 10 Pro version
>>> 1607.
>>> I need to read some .mdb files.  I've tried following the directions
>>> the Paradox Help file - putting the Access table name into the BDE
>>> Administrator
>>> and selecting IDDA3532.DLL in the DLL32 field.  The help file refers
>>> "opening
>>> MS access tables in paradox using the MS Access alias you just created,"
>>> but I'm not sure what "Alias" means in this context.
>>> Having followed all the steps, when I attempt to use the Open Table dialogue
>>> and click on the directory holding the .mdb file, I get an error message
>>> "-2147221164" and then (clicking the forward arrow) "Table."
>>> If I attempt to Import the MS Access file using the Import utility, the
>>> message
>>> is a little more comprehensible:
>>> "Could not open" [the Access table name].  You need to install the Data
>>> Access
>>> Objects (DAO).
>>> (The quotation marks appear exactly as above in the error message.)
>>> Can someone out there give me a step-by-step guide to installing whatever
>>> it is that I need and then configuring BDE and Paradox correctly?
>>> Many thanks,
>>> Andy in Sydney
>>> ---
>>> This email has been checked for viruses by Avast antivirus software.

Copyright © 2004