Increase response time

[Ginger]

I have an mdb with linked tables. There are at most 5
users at one time. The largest table has 900 records, but
there are a total of 22 tables. I need to increase the
response time. What in Access has the most bearing on
this? Should I look at relationships?

 

[Sandra Daigle]

Hi Ginger,

There are many ways to improve your application's performance:

Take a look at the following articles.

http://www.granite.ab.ca/access/performancefaq.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300216
Keep a Jet 4.0 Database in Top Working Condition

 

[Wayne Morgan]

I assume you mean "reduce" response time.

You will find some good tips on improving performance here.

http://www.granite.ab.ca/access/performancefaq.htm