I received this document from Epicor but I am getting the error
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
can anyone tell me what I need to do
Thanks
Rhonda
--- In vantage@yahoogroups.com, "Leonard, Jeremy" <jleonard@k...>
wrote:
Indexes you can link to on a table.
access. )
http://groups.yahoo.com/group/vantage/files/.
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
can anyone tell me what I need to do
Thanks
Rhonda
--- In vantage@yahoogroups.com, "Leonard, Jeremy" <jleonard@k...>
wrote:
> The Vantage Customer table has to many indexes for Access to handle.a document on how to do this)
> Your options are:
> 1) Create a view in Progress to output Customer table. (Epicor has
> 2) Dump the table to a flat file regularly and link it in Access.then link it to Access. (SQL Server does not limit the number of
> 3) Setup a View in SQL Server to the Progress database via ODBC
Indexes you can link to on a table.
>driver I
> Good luck
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Ordway, Bruce [mailto:bruceo@b...]
> Sent: Friday, November 07, 2003 11:11 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Access and ODBC import errors
>
>
> Hi,
>
> When I try to import data into MS Access using the Merant ODBC
> get an error.the
> In Access I go to "Get External Data",
> select my Vantage ODBC source,
> and select the table PUB.Customer.
>
> Then receive this error message:
> "The operation failed. There are too many indexes on table
> 'VtQoDefTemp0000'. Delete some of the indexes on the table and try
> operation again."problem.
>
> I'm using Access 2000 and Windows XP.
> I tried upgrading to the latest Jet and MDAC but I still receive the
> error.
> I've tried it on several other workstations and get the same
>I'd
> I use Access to perform "quick and dirty" data analysis A LOT, so
> like to know if there is a fix for this.must have already linked your email address to a yahoo id to enable
>
> Thanks,
> Bruce Ordway
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
access. )
> (1) To access the Files Section of our Yahoo!Group for ReportBuilder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:http://groups.yahoo.com/group/vantage/links
>http://docs.yahoo.com/info/terms/
> Your use of Yahoo! Groups is subject to