Access files?

[RonB]

I've brought an M$ Access file home to work on -- and I was hoping I
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.

[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.

[RonB]

Post by 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.

[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.
Leave them blank unless the table is password protected.

[RonB]

Post by 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]

Post by 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]

Post by 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.

Post by RonB
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.

Post by RonB
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]

Post by 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]

Post by 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.

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.

[Klatu Battlehammer]

Ron

Why don't you just export the tables you need from within Access.

David Davis

Post by RonB
I've brought an M$ Access file home to work on -- and I was hoping I
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.

[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?

Post by Klatu Battlehammer
Ron
Why don't you just export the tables you need from within Access.
David Davis

Post by RonB
I've brought an M$ Access file home to work on -- and I was hoping I
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.

[Bertil Isberg]

<<
Paradox 10 was a part of Office 2000? Its that old when was Paradox 9.0
released then?
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.

< 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>

[RonB]

Post by Bertil Isberg
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.

[RonB]

Post by 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.

Yep.

Post by Gonefishing
Paradox 10 was a part of Office 2000? Its that old when was Paradox
9.0 released then?

Office 2002.

Thanks for posting.

[RonB]

Post by Klatu Battlehammer
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.

[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

Post by RonB

Post by Klatu Battlehammer
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
"There's a story there...somewhere"

[RonB]

Post by 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.

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.