Access files?
RonB
wouldn't have install Access on this computer because, what I really
want to do, is just get it converted to dBASE DOS format. I have
Paradox 10. When I try to import the Access file I get a "Data Access
Objects" error and I'm told to install the "DAO" files. I haven't got a
clue where they are. When I look at the help file under importing
Access files, it tells me to go to BDE in my Utilities subdirectory and
run through a setup process -- but BDE isn't there -- and I'm not sure
how to get it there. The installation program tells me I have it (I
understand Paradox *has* to have BDE) but darned if I know how to run
it.
What am I doing wrong? (Err... probably should just point me to the
problem -- we don't have all month for this "what am I doing wrong?"
thing.)
Thanks for any advice.
--
RonB
"There's a story there...somewhere"
Bertil Isberg
Ron
<<
When I look at the help file under importing
Access files, it tells me to go to BDE in my Utilities subdirectory and
run through a setup process
>>
In previous versions, e g WP Offcie 2000, the BDE Admin was found in
Utilities, but not in WPO 2002. You'll find it through Start - Settings
- Control Panel - BDE Administrator.
Note: The BDE native Access driver does probaly not support the version
of Access you are using now, so IMO, the best way to get at Access is to
create an ODBC datasource for the Access database. If you specify
AutoOdbc=TRUE in BDE Admin - Configuration tab - System - Init, you'll
get an alias defined automatically for you in Paradox.
--
Bertil Isberg
CTECH
FAQ newsgroup: corel.wpoffice.paradox-faq
Paradox Buglist: http://w1.826.comhem.se/~u82608896/
remove spamfilter (reversed) to reply
Klatu Battlehammer
Ron
Why don't you just export the tables you need from within Access.
David Davis
In article <Xns95A6374A6BE6F...@130.133.1.4>,
ronbN...@bliz.org says...
Gonefishing
Not to be a pain in the tush. But probably because the person took the file
home with them and wanted to do the conversion from home without needing to
install access at home.
Paradox 10 was a part of Office 2000? Its that old when was Paradox 9.0
released then?
"Klatu Battlehammer" <kbattl...@charter.net> wrote in message
news:MPG.1c080845d...@cnews.corel.com...
Bertil Isberg
<<
Paradox 10 was a part of Office 2000? Its that old when was Paradox 9.0
released then?
>>
is part of WP Office 2000, which was released in 1999. Problem is not
Paradox but the BDE, which hasn't been updated since 2001 and what I know it
does not support Access 2000. Using ODBC, you can.
< From BDE ADMIN >
The name of the driver's 32-bit Dynamic Link Library (*.DLL). Driver
IDDA3532.DLL (default) for Access 97 and Jet Engine 3.5. Driver IDDAO32.DLL
for Access 95 and Jet Engine 3.0.
< /From BDE ADMIN>
--
Bertil Isberg - CTECH
Paradox buglist:
online: http://w1.826.comhem.se/~u82608896/
FAQ newsgroup: corel.wpoffice.paradox-faq
RonB
>
> Ron
> <<
> When I look at the help file under importing
> Access files, it tells me to go to BDE in my Utilities subdirectory
> and run through a setup process
> >>
>
> In previous versions, e g WP Offcie 2000, the BDE Admin was found in
> Utilities, but not in WPO 2002. You'll find it through Start -
> Settings - Control Panel - BDE Administrator.
>
> Note: The BDE native Access driver does probaly not support the
> version of Access you are using now, so IMO, the best way to get at
> Access is to
> create an ODBC datasource for the Access database. If you specify
> AutoOdbc=TRUE in BDE Admin - Configuration tab - System - Init,
> you'll get an alias defined automatically for you in Paradox.
I looked into it. Thanks. No luck yet. I've gotten to a screen that
asks for a user name and password (?) but haven't had much luck
otherwise.
I'll look into the manual.
Thanks.
RonB
> Ron
>
> Why don't you just export the tables you need from within Access.
>
> David Davis
Because I don't have Access on my computer and I don't want to load it.
I just thought I could use Paradox for the job -- but have used Access
at work to export the file now (though I still want to know how to use
Paradox for this).
Thanks for the post.
RonB
> Not to be a pain in the tush. But probably because the person took
> the file home with them and wanted to do the conversion from home
> without needing to install access at home.
Yep.
> Paradox 10 was a part of Office 2000? Its that old when was Paradox
> 9.0 released then?
Office 2002.
Thanks for posting.
RonB
> Paradox 10 is part of WP Office 2002 which was released in 2001.
> Paradox 9 is part of WP Office 2000, which was released in 1999.
> Problem is not Paradox but the BDE, which hasn't been updated since
> 2001 and what I know it does not support Access 2000. Using ODBC, you
> can.
I've got to figure out what ODBC is. Sorry for being so ignorant.
Thanks again for the earlier advice.
Anders Jonsson
If you have Excel you should be able to open the Access database from there
and from there export/save it to a format that Paradox can read.
Anders Jonsson
"RonB" <ronbN...@bliz.org> skrev i meddelandet
news:Xns95A6BC7CF352C...@130.133.1.4...
Bertil Isberg
Ron
<<
No luck yet. I've gotten to a screen that
asks for a user name and password (?) but haven't had much luck
otherwise.
>>
RonB
>
> Ron
> <<
> No luck yet. I've gotten to a screen that
> asks for a user name and password (?) but haven't had much luck
> otherwise.
>>>
> Leave them blank unless the table is password protected.
Thanks.
RonB
> If you have Excel you should be able to open the Access database from
> there and from there export/save it to a format that Paradox can
> read.
I've got Excel, but I don't have that installed either. And we haven't
had much luck opening these Access databases with Excel at work. Only
one of our computers has Access -- and that's where they have going
through.
RonB
>
> Ron
> <<
> No luck yet. I've gotten to a screen that
> asks for a user name and password (?) but haven't had much luck
> otherwise.
>>>
> Leave them blank unless the table is password protected.
Now I get a "Key Violation." The BDE Error code is "9729." If I look at
details I get "[Microsoft][ODBC Microsoft Access Driver]General error
Not enough information to connect to this DSN with SQLConnect. Use
SQLDriverConnect."
I'll see if I can figure what SQLConnect is.
Bertil Isberg
Ron
<<
Now I get a "Key Violation." The BDE Error code is "9729." If I look at
details I get "[Microsoft][ODBC Microsoft Access Driver]General error
Not enough information to connect to this DSN with SQLConnect. Use
SQLDriverConnect."
>>
Which version of Access are your using?
How did you configured your ODBC datasource? As a system DSN or a User Dsn?
Can you open registry, run regedit, and look at this key
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\YOUR ODBC DSN NAME]
or
[HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\YOUR ODBC DSN NAME]
Then use Register - Export and export it to a reg file. Zip the file and
send it to me at
bertil.isberg AT comhem.se
I won't accept .reg file as attachment.
RonB
> Ron
> <<
> Now I get a "Key Violation." The BDE Error code is "9729." If I look
> at details I get "[Microsoft][ODBC Microsoft Access Driver]General
> error Not enough information to connect to this DSN with SQLConnect.
> Use SQLDriverConnect."
>>>
>
> Which version of Access are your using?
Unfortunately, I don't know.
> How did you configured your ODBC datasource? As a system DSN or a
> User Dsn?
No. I gave up. This was the file and I've already used Access to save
in dBASE format.
> Can you open registry, run regedit, and look at this key
>
> [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\YOUR ODBC DSN NAME]
> or
> [HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\YOUR ODBC DSN NAME]
>
>
> Then use Register - Export and export it to a reg file. Zip the file
> and send it to me at
> bertil.isberg AT comhem.se
>
> I won't accept .reg file as attachment.
If I try this again I'll take a closer look. Sorry for the trouble.
RonB
> I've already used Access to save
> in dBASE format.
Access...at work. I never loaded Access on my computer.
Michael Israel
Ron,
I like doing data conversions. You can e-mail me privately (remove
spamless). I'll send you the Paradox tables (if I'm successful!) and then
tell you step by step how I did it. It is not entirely intuitive, but the
conversion as well as native manipulation of data works very well. I've
often queried and reported directly from Access files from Paradox for
colleagues as well as converting when necessary. Not a problem.
RonB
Hi Michael,
I should have responded specifically to your kind offer earlier. I'm
sorry to say, but in this case I wouldn't feel comfortable passing on
the file. It's not really that sensitive of information, but we are
contracting to a government agency and that pretty much disallows doing
this.
But I *do* understand the desire to convert files. I used convert
people's WordStar files for the fun of it -- and still get the
opportunity to do so every now and then.
Thanks for the offer.