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
__________________________________________