ODBiC Discussion Board


RE: ODBiC SELECT statement never completes, Dave, 11-12-2003

Always create your queries in Access!

by Darryl Taylor, November 15, 2003 16:33

Be sure to create your queries in Access and ensure that a good index exists over the keyed values. Creating such a complex SQL statement is a pain in the neck plus it doesn't tend to get optimized by Access. You will find that your life will be much easier. :o)


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.