maximum number of indexes per SQL table that Access (jet) can dealwith?

  • Thread starter a a r o n . k e m p f
  • Start date
A

a a r o n . k e m p f

why is there a maximum number of indexes per SQL table that Access
(jet) can deal with?
is it really the count of indexes + statistics?

I've seen plenty of documentation that states that typically DSS
systems have twice as much index space as data space.. So I don't
think that it's a case of 'over-indexing'

I'm just tired of a crippled Jet front end and other people making me
'temporarily drop my indexes' so that they can link to my tables using
Jet.

has this bug gone away with Access 2007?
Is it going away with Access 2010?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Losing SQL Indexes when linking into Access 2000 0
Maximum record size and maximum number of records 3
Whats the maximum number of rows Access 2007 can take? 3
Jet vs. SQL 1
Access mdb or SQL Server Back End? 4
Maximum number of indexes to one table 1
What is the overhead of a text column in access? 17
Indexes on multiple fields -- redundant to reindex? 5

Top