ODBC Connections

  • Thread starter Thread starter gumby
  • Start date Start date
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?
 
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.
 
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
 
You must log in or register to reply here.

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

update query ODBC--call failed 3
Access 2010 append query to SQL is very slow 0
add a value to a date 8
Using ODBC Connection Query Error: Non-Updatable Query 4
query links to SQL server and mdb table 1
Data Definition Query 3
ODBC Pass-through query with parameter from table 5
Access stripping decimal places in query 1

Back
Top