ODBC Connections

G

gumby

Why can you not link a table due to too many indexes, but can access
that same SQL bases table through Access Data Project?
 
B

Brendan Reynolds

Because the JET database engine, which is used when you link tables, has a
lower maximum number of indexes (32) than SQL Server (1 clustered, 249
nonclustered, according to SQL Server Books Online). ADPs connect directly
to SQL Server and do not use JET, so in an ADP the JET limitation does not
apply.
 
G

gumby

Thank you, it makes more sence to me now. ADP is just so much
different, plus I have been unable to get Dcount to work in the reports
or functions like =sum(Abs([RecordDate]=Date()-1)) to work. I have a
query setup for a report, but I need to count daily totals, prior day
totals, and a running count.

David
 
Top