Too many indexes

Yahoo Archive
1
The solution is to create an SQL View and then query from the view instead
of the table.



Regards,



Michael



Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please immediately notify me by
telephone and permanently delete the original and any copy of any email and
any printout thereof.




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ken Taylor
Sent: Wednesday, March 05, 2008 8:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Too many indexes



Is anyone using Microsoft Access with Vantage 8.03? I'm attempting to link
the Customer table and I get the 'too many indexes on table' error and
cannot query. Any thought will be appreciated.

Ken.

__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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





[Non-text portions of this message have been removed]
2
Is anyone using Microsoft Access with Vantage 8.03? I'm attempting to link the Customer table and I get the 'too many indexes on table' error and cannot query. Any thought will be appreciated.



Ken.




____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


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