Speeding up access programs with linked tables

  • Thread starter Thread starter Nathan Niewohner
  • Start date Start date
N

Nathan Niewohner

The business that i help program is running with alot of access programs and
many of them seem to be extremely slow when they are using linked tables.
what are some possible solutions for this situation?
Thanks,

Nathan
 
What are the linked to? Other Access databases or some other database such as
SQL Server or Oracle?

If another database, look into creating views in them that gathers up the
data especially if there are table joins. Also research pass-through queries
where the work in done on the database server and not Access.

If linked to other Access databases, then proper indexing of the correct
fields can make a difference.

Tony Toews has some suggestions. Check out:
http://www.granite.ab.ca/access/performancefaq.htm
 
We are currently running make table queries to copy the information to the
program we are using so we dont have to be tied to the server at all times.
 
Back
Top