|Subject:||Re: Opening MS Access files in Paradox 11
|Date:||27 Sep 2019 06:13:48 -0400
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 <firstname.lastname@example.org> 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,
>> Sydney Australia
>> "Steven Green" <email@example.com> wrote:
>>> are you a paradox guy, or an access guy? might make a difference in how
>>> 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:firstname.lastname@example.org...
>>> I'm using Paradox 22.214.171.1246 on a computer running Windows 10 Pro version
>>> 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
>>> and selecting IDDA3532.DLL in the DLL32 field. The help file refers
>>> 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
>>> is a little more comprehensible:
>>> "Could not open" [the Access table name]. You need to install the Data
>>> 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.