Importing Password Protected Paradox 5.0 Tables Into MS Access 2000 
Author Message
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000

I'm working on a project that requires me to import some Paradox tables into
MS Access.
I can import via the MS Access UI or with the DoCmd.TransferDatabase method
most of
the Paradox 5.0 tables in my current work-from-home project.  However, those
that are password protected give me the following error:
       Unexpected Error From External Database Driver (10498)
When I open these in my very old version of Visual dBase 5.5 (I don't have
Paradox installed at home), I'm prompted for the password and when I enter
it, the table will open.

The Access UI is not giving me a prompt and the TransferDatabase method does
not have a password argument.  I'm well and truly stuck.  Any help or hints
will be greatly appreciated!

*****
* J. J. Campbell
* Arlington, {*filter*}ia

*****



Fri, 02 Jan 2004 05:33:24 GMT
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000

Quote:

> The Access UI is not giving me a prompt and the TransferDatabase method does
> not have a password argument.  I'm well and truly stuck.  Any help or hints
> will be greatly appreciated!

that's an Access question.. you should ask it on an Access newsgroup..

--
------------------------------

Steve Green
Waldorf Maryland USA

http://www.diamondsg.com

------------------------------
Diamond Software Group, Inc.
Corel CTech - Paradox Support
------------------------------
Diamond Sports Gems
Sports Cards and Memorabilia
------------------------------



Fri, 02 Jan 2004 05:53:33 GMT
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000
I did (twice) and didn't get a single responses.  Do you know if in Paradox
for Windows 5.0 there is a quick way to open the database, supply the
password and then copy all the tables to another subdirectory with the
password  protection disabled on the copy?


Quote:

> > The Access UI is not giving me a prompt and the TransferDatabase method
does
> > not have a password argument.  I'm well and truly stuck.  Any help or
hints
> > will be greatly appreciated!

> that's an Access question.. you should ask it on an Access newsgroup..

> --
> ------------------------------

> Steve Green
> Waldorf Maryland USA

> http://www.diamondsg.com

> ------------------------------
> Diamond Software Group, Inc.
> Corel CTech - Paradox Support
> ------------------------------
> Diamond Sports Gems
> Sports Cards and Memorabilia
> ------------------------------



Sat, 03 Jan 2004 08:31:56 GMT
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000
JJ,

This can be done manually or in code.  The details depend on your
environment (could the tables be in use at the time they're
copied or will you have exclusive access).

Regards,

Liz
---
http://www.paradoxcommunity.com/
http://www.aros.net/~law/

Quote:

> I did (twice) and didn't get a single responses.  Do you know if in Paradox
> for Windows 5.0 there is a quick way to open the database, supply the
> password and then copy all the tables to another subdirectory with the
> password  protection disabled on the copy?



Sat, 03 Jan 2004 09:04:19 GMT
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000
Liz,
There are only a couple of staff who use the system so it is easy for me to
get exclusive use.  A present we have no in-house Paradox talent.  I'm an
old Clipper-head and Visual dBase user currently using MS Access so if you
tell me how to do this, I hopefully will be able to follow your
instructions.

This application was developed in Paradox 5.0 and pre-dates the
object-oriented code now in use.

I really appreciate your help - I'm well and truly stuck and can't make any
headway on this project which has been a pet peeve of my Department head for
several years.
jj


Quote:
> JJ,

> This can be done manually or in code.  The details depend on your
> environment (could the tables be in use at the time they're
> copied or will you have exclusive access).

> Regards,

> Liz
> ---
> http://www.paradoxcommunity.com/
> http://www.aros.net/~law/


> > I did (twice) and didn't get a single responses.  Do you know if in
Paradox
> > for Windows 5.0 there is a quick way to open the database, supply the
> > password and then copy all the tables to another subdirectory with the
> > password  protection disabled on the copy?



Sat, 03 Jan 2004 21:33:43 GMT
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000
JJ,

If you want to do it manually, then open Paradox, issue the
passwords and do one of the following:

1) If you do NOT need indices, validity checks, etc.  Run a
checkplus query to get all the data into a new table (you can use
the query's properties to set the target table name and location
- as well as other stuff).  Then you could save the queries and
just re-run them as needed.

2) If you DO need indices, etc.  Use the Table Copy option
(forget exactly where it is in v5.0 - look for a Tools menu) and
then restructure the target table to remove the password(s).

3) Use code.  The best way to do this would really depend on a
lot of details I don't know.  If you're interested, let us know
and we'll help.

Liz

Quote:

> Liz,
> There are only a couple of staff who use the system so it is easy for me to
> get exclusive use.  A present we have no in-house Paradox talent.  I'm an
> old Clipper-head and Visual dBase user currently using MS Access so if you
> tell me how to do this, I hopefully will be able to follow your
> instructions.

> This application was developed in Paradox 5.0 and pre-dates the
> object-oriented code now in use.

> I really appreciate your help - I'm well and truly stuck and can't make any
> headway on this project which has been a pet peeve of my Department head for
> several years.
> jj



Sat, 03 Jan 2004 21:59:35 GMT
 Importing Password Protected Paradox 5.0 Tables Into MS Access 2000


Quote:
>JJ,

>If you want to do it manually, then open Paradox, issue the
>passwords and do one of the following:

>1) If you do NOT need indices, validity checks, etc.  Run a
>checkplus query to get all the data into a new table (you can use
>the query's properties to set the target table name and location
>- as well as other stuff).  Then you could save the queries and
>just re-run them as needed.

>2) If you DO need indices, etc.  Use the Table Copy option
>(forget exactly where it is in v5.0 - look for a Tools menu) and
>then restructure the target table to remove the password(s).

I just moved from v5 to v9 a short time ago.  The easiest way to get
to Copy in V5 is to right click on the source table's name and select
"copy" from the resulting menu.  I'm fairly sure that the function can
be activated from the Tools menu, too, but the old computer's in
another room and not plugged in right now.
Quote:

>3) Use code.  The best way to do this would really depend on a
>lot of details I don't know.  If you're interested, let us know
>and we'll help.

>Liz


>> Liz,
>> There are only a couple of staff who use the system so it is easy for me to
>> get exclusive use.  A present we have no in-house Paradox talent.  I'm an
>> old Clipper-head and Visual dBase user currently using MS Access so if you
>> tell me how to do this, I hopefully will be able to follow your
>> instructions.

>> This application was developed in Paradox 5.0 and pre-dates the
>> object-oriented code now in use.

>> I really appreciate your help - I'm well and truly stuck and can't make any
>> headway on this project which has been a pet peeve of my Department head for
>> several years.
>> jj



Sat, 03 Jan 2004 23:28:58 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. how do i access a password protected MS-ACCESS db without the password

2. Accessing password protected paradox table

3. Accessing data from password protected paradox table

4. HOW TO LINK PARADOX TABLE WITH PASSWORD IN ACCESS 2000

5. Password protected Access 2000 and DC.

6. VB with Access 2000 (Password Protected)

7. Opening Password protected Access 2000 DB

8. Access 2000 Password protected /Connection String from VB

9. Access 2000 Password protected DB and intrisic VB Data Control

10. Access 2000 password protected db an DC

11. Can't Import MS Access 2000 Table???

12. Importing MS Access Table into SQL 2000


 
Powered by phpBB® Forum Software