From: a a r o n . k e m p f on 7 Apr 2010 17:06
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
has this bug gone away with Access 2007?
Is it going away with Access 2010?