link a table with many indexes

[snoopyhr]

I have this table that I need to link (not import) . the problem is the table has too many index and it fails to link. I was wondering if there is a way to link the table and perfom query. he error I get is " the table contains too many index, delete some and try again", since this table is part of ERP system , doing so is not possible . What I am after is some how to be able to link to table without the data, just the field, and then I can use the query to pick and choose the fields I need.

Thank you in advance for your help. Appreciated.

 

[SydneyGeek]

I got this from a post on dbforums --

Official limits in Access databases

Maximums--
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048; the actual number may be less because of tables
opened internally by Microsoft Access
Table size 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the
user interface;
1 gigabyte of character storage when entering data programmatically
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes 4,000
Number of characters in a field property setting 255

The latest version (2007) is pretty well identical to earlier versions with respect to these limits. Do you have any idea how many limits there are in your target table?

As for pulling the data via a query: you may be able to. What is the DB engine that you want to connect to? Once you have the data, does it matter if it is read-only?

Denis

 

[snoopyhr]

I an trying to pull the table from ODBC , the database engine if not mstaken is Progress

 

[giacomo]

instead of linking the table maybe you can write a pass-thru query and get only those records that you need.