|Subject:||Re: Opening MS Access files in Paradox 11
|Date:||16 Jul 2017 21:32:09 -0400
Hi Steven, I've only ever used Paradox; no experience whatsoever in MS Access.
(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 I
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 so
I can query, edit, format them, etc. Is that possible and, if so, what extra
system files do I need?
All help is gratefully appreciated.
"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 as
>such, instead of changing all the references to it in your code
>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 in
>the Paradox Help file - putting the Access table name into the BDE
>and selecting IDDA3532.DLL in the DLL32 field. The help file refers to
>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
>(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?
>Andy in Sydney
>This email has been checked for viruses by Avast antivirus software.