brassie
|
Posted: 06/20/2003, 9:14 PM |
|
CCS2.1..20, MSACCESS2000, Win2KProSP2.
Just discovered this - anyone anything similar?
When connection is to MSACCESS having linked tables/qry files cannot see
linked tables or qry files in any dialog in CCS - so can't use linked tables
in query builder., can't use qry views.
?? Any clues anywhere??
TIA,
keijen
|
|
|
Doru Apostolescu
|
Posted: 06/21/2003, 12:32 AM |
|
Yes, the linked tables are not shown in an ODBC or JET connection to the
MDB. Those are visible only in MS Access IDE.
--
Doru APOSTOLESCU
Certified NT Admin
TEHNOPLUS Ltd.
doru@tehnoplus.com
"brassie" <Brassie@mantis.com.uk> wrote in message
news:bd0m36$jnf$1@news.codecharge.com...
> CCS2.1..20, MSACCESS2000, Win2KProSP2.
> Just discovered this - anyone anything similar?
>
> When connection is to MSACCESS having linked tables/qry files cannot see
> linked tables or qry files in any dialog in CCS - so can't use linked
tables
> in query builder., can't use qry views.
>
> ?? Any clues anywhere??
>
> TIA,
> keijen
>
>
|
|
|
FLhr
|
Posted: 06/21/2003, 10:45 AM |
|
Have you tried creating another ODBC definition for the linked tables?
"brassie" <Brassie@mantis.com.uk> wrote in message
news:bd0m36$jnf$1@news.codecharge.com...
> CCS2.1..20, MSACCESS2000, Win2KProSP2.
> Just discovered this - anyone anything similar?
>
> When connection is to MSACCESS having linked tables/qry files cannot see
> linked tables or qry files in any dialog in CCS - so can't use linked
tables
> in query builder., can't use qry views.
>
> ?? Any clues anywhere??
>
> TIA,
> keijen
>
>
|
|
|
brassie
|
Posted: 06/21/2003, 10:26 PM |
|
Its strange -
If I make a dsn I can see the linked tables and qry files,Ok, use them as
expected. But DSN is not an option for our deliverables.
If I use the SAME connection string in CC2 I can see the links and qry
files, and can use them as expected.
It's just in CCS , with a 'point-click' built connection string , that they
are not appearing in the dialogs (using the Jet OLEDB 4.0)
keijen
|
|
|
|