how do I speed Access handling of MS SQL data

G

Guest

I have an Access database where all of the data resides online in a MS SQL
database. Processing any of the data, whether through a query, report or form
takes way way too much time. How can I speed that up?
 
G

Guest

Is there a network involved? If so, is it a LAN (Local Area Network) or a
WAN (Wide Area Network)? See the article by Access MVP Albert Kallal:

Using a wan with ms-access? How fast, how far?
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html


Are your fields indexed appropriately (ie. fields used to specify criteria
and/or sort orders)? What type of data access are you using (linked ODBC
tables, ADO, etc.)? If using linked tables, try deleting all table links,
compacting the database, and creating them from scratch again. This is
important to do anytime you make a schema change in the BE database (add or
remove an index, add or remove a field, etc.).

You really haven't given much information for anyone to go on....


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 

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

Pass Through to SQL Server Optimization Questions 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Access Access Report Works on One Machine but not Another 3
Best way to deploy Access read-only database that is linked to SQL tables 6
Speed up Access 2
How to link a Access FE to SQL Server BE 10
SQL Server 2005 as my BACKEND DATABASE, MSAccess Front-end with fo 4
DBF linked on ACCESS Query 1

Top