[6.1] Customer Table Too many Indexes for ODBC

Yahoo Archive
1
Thanks Brian. I couple people sent copies and one of them has uploaded to the group files as well. So next time I (or anyone else) goes searching maybe it will be easier to find. We are shutdown today so if I need to re-start the server this is a good day to do that sort of thing.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Stenglein
Sent: Thursday, July 03, 2008 7:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [6.1] Customer Table Too many Indexes for ODBC


Todd,

Contact support, they have documentation on creating a view for a
table with too many indexes. I remember it wasn't too hard with the
directions, but it was a long time ago that I did it and I'm not even
going to attempt to dust out that corner of my brain this morning.

Good luck!

Brian Stenglein

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Todd Caughey <caugheyt@...> wrote:
>
> I know I have seen posts about how to do something like a Foreign
Key View for getting at the Customer table from Access via ODBC but I
can't find them when I search the old posts. Partly because I am not
sure what it is I am searching for.
>
> If there is a support article number or a location for
documentation on how to handle this could someone please reply with
that? I am coaching my part-time VB/Access whiz-kid assistant in
some reports from the Vantage DB and we've hit the Customer table
roadblock..
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I know I have seen posts about how to do something like a Foreign Key View for getting at the Customer table from Access via ODBC but I can't find them when I search the old posts. Partly because I am not sure what it is I am searching for.

If there is a support article number or a location for documentation on how to handle this could someone please reply with that? I am coaching my part-time VB/Access whiz-kid assistant in some reports from the Vantage DB and we've hit the Customer table roadblock..

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
3
Todd,

Contact support, they have documentation on creating a view for a
table with too many indexes. I remember it wasn't too hard with the
directions, but it was a long time ago that I did it and I'm not even
going to attempt to dust out that corner of my brain this morning.

Good luck!

Brian Stenglein

--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> I know I have seen posts about how to do something like a Foreign
Key View for getting at the Customer table from Access via ODBC but I
can't find them when I search the old posts. Partly because I am not
sure what it is I am searching for.
>
> If there is a support article number or a location for
documentation on how to handle this could someone please reply with
that? I am coaching my part-time VB/Access whiz-kid assistant in
some reports from the Vantage DB and we've hit the Customer table
roadblock..
>
> Thanks,
> Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>