Help with slow database

[Cam]

Hello,

I have a database with 3 couple OBDC link tables, I created a form with
multiple filters, etc... For some reasons, it is taking a long time to
process the query in the selection boxes, etc.. Even now saving the database
took couple times longer than usual. Is there a way to speed it up? Thanks

 

[Jackie L]

Are you writing back to the ODBC tables or just reading the data?

If just reading the data, in order to speed up queries with ODBC tables, it
is best to bring in the data one table at a time (can make temp tables) and
then link the data after it is in Access. Often, linking two ODBC tables in
a query is much slower than running two separate queries.

Also, if you have the data in Access, using it for combo boxes is much
faster than hitting the ODBC. What I do many times is create an Update
routine to update all of the ODBC data into Access before doing
processing/reporting.

Hope this helps.

 

[John W. Vinson]

Hello,

I have a database with 3 couple OBDC link tables, I created a form with
multiple filters, etc... For some reasons, it is taking a long time to
process the query in the selection boxes, etc.. Even now saving the database
took couple times longer than usual. Is there a way to speed it up? Thanks

Have you compacted and repaired the database? Are you maintaining an open
connection? see
http://www.granite.ab.ca/access/performancefaq.htm
for some "best practices" in such cases.