Very Computer

by **Ma Dalto** » Sat, 01 Sep 2001 07:10:47

Hi, in access2000 I dont have any problem to attach paradox's tables but
under access97, nothings goes. I already have the BDEadmin and an one
define ODBC DSN. May be one or more settings are not correct.

What do I check first?

thank you

by **Keith Rodge** » Sat, 01 Sep 2001 07:57:14

Quote:> Hi, in access2000 I dont have any problem to attach paradox's tables but
> under access97, nothings goes. I already have the BDEadmin and an one
> define ODBC DSN. May be one or more settings are not correct.

Somewhere on the M$ Office97 install CD is a "data access pack" that
installs extra filters to Access97 that will allow Paradox tables to be
imported or linked. This data access pack also used to be downloadable
from the M$ web site.

--
---------------------------------------------------------------------
Keith Rodgers Technical Advisor Energy Safety Service |
http://www.consumer-ministry.govt.nz/ESS/Index.html |

Phn:+64 4 472 0030 Fax:+64 4 460 1365 PO Box 1473 Wellington NZ |
Information superhighway => Enormous hairy pig with fan |
Opinions (and anagrams) are exclusively my own |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

by **Ma Dalto** » Sun, 02 Sep 2001 05:52:13

Thanks,
going better but still have error. Table's name are more than 8 char long
and error message shows a cut table's name to 8 char and says 'tables not
found' (??)
For testing I try to rename tables to 8 or less characters and Bingo (except
for table where I have .val file), but I cannot rename any table's name for
this database.

In fact, what are .val files?

thanks again

> > Hi, in access2000 I dont have any problem to attach paradox's tables but
> > under access97, nothings goes. I already have the BDEadmin and an one
> > define ODBC DSN. May be one or more settings are not correct.

> Somewhere on the M$ Office97 install CD is a "data access pack" that
> installs extra filters to Access97 that will allow Paradox tables to be
> imported or linked. This data access pack also used to be downloadable
> from the M$ web site.

> --
> ---------------------------------------------------------------------
> Keith Rodgers Technical Advisor Energy Safety Service |
> http://www.consumer-ministry.govt.nz/ESS/Index.html |

> Phn:+64 4 472 0030 Fax:+64 4 460 1365 PO Box 1473 Wellington NZ |
> Information superhighway => Enormous hairy pig with fan |
> Opinions (and anagrams) are exclusively my own |
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

by **Michael Israel, M.D** » Mon, 03 Sep 2001 01:23:47

Instead of re-naming tables, copy the tables and give them a new name. This
will change all files associatied with the table such as .val, .px etc.

> Thanks,
> going better but still have error. Table's name are more than 8 char long
> and error message shows a cut table's name to 8 char and says 'tables not
> found' (??)
> For testing I try to rename tables to 8 or less characters and Bingo (except
> for table where I have .val file), but I cannot rename any table's name for
> this database.

> In fact, what are .val files?

> thanks again

> > > Hi, in access2000 I dont have any problem to attach paradox's tables but
> > > under access97, nothings goes. I already have the BDEadmin and an one
> > > define ODBC DSN. May be one or more settings are not correct.

> > Somewhere on the M$ Office97 install CD is a "data access pack" that
> > installs extra filters to Access97 that will allow Paradox tables to be
> > imported or linked. This data access pack also used to be downloadable
> > from the M$ web site.

> > --
> > ---------------------------------------------------------------------
> > Keith Rodgers Technical Advisor Energy Safety Service |
> > http://www.consumer-ministry.govt.nz/ESS/Index.html |

> > Phn:+64 4 472 0030 Fax:+64 4 460 1365 PO Box 1473 Wellington NZ |
> > Information superhighway => Enormous hairy pig with fan |
> > Opinions (and anagrams) are exclusively my own |
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

by **Martin Ferwer** » Wed, 05 Sep 2001 09:52:03

On Fri, 31 Aug 2001 16:52:13 -0400, "Ma Dalton"

.VAL files are where the validity checks for the columns in the table
are stored, Min and Max allowable values, that kind of stuff. I think
these files can be deleted without hurting the data in the tables, but
you will lose the validity checks of course. For info on associated
table files look at:
http://www.paradoxcommunity.com/desktop/tablerp.htm

Quote:>Thanks,
>going better but still have error. Table's name are more than 8 char long
>and error message shows a cut table's name to 8 char and says 'tables not
>found' (??)
>For testing I try to rename tables to 8 or less characters and Bingo (except
>for table where I have .val file), but I cannot rename any table's name for
>this database.

>In fact, what are .val files?

Very Computer

attaching paradox tables into access97

attaching paradox tables into access97

attaching paradox tables into access97

attaching paradox tables into access97

attaching paradox tables into access97

attaching paradox tables into access97