Optimizing the database

[Guest]

I've developed a database that uses quite a few queries, macros, and forms.
There are two databases, front-end and back-end, which are shared by multiple
users in a LAN/ WAN environment. The problem is the forms load very slowly
whenever they're executed. I know for sure the end-users will get frustrated
as we will use this database during customer interactions. Any suggestions
on how I can optimize this database?

Thanks,
Nyla

 

[Allen Browne]

Tony Toews has an excellent list of issues for you to work through in:
Access Performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Joseph Meehan]

Tony Toews has an excellent list of issues for you to work through in:
Access Performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm

Also make sure the forms are on the front end.

 

[Guest]

Thank you Allen and Joseph. I'll check this out.