Other ways to improve database efficiency/responses?

[perryc]

All, I have a database that is growing in size (8MB for the Backend) via network. It is painful somedays when traffic is heavy. What I have done, with the help of some folks here, to write a DAO to keep the Database open. Well, I think I see a little improvement but wonder if there are other thoughts? Ty in advance.

p.s.: I did search up on the web about possible solutions but some involves me re-writing the database or very extensive changes which I don't have the time for that. I was wondering if there are some other means. Ty again.

[ranman256]

8 meg is nothing.
compact frequently (backups too)
use unbound forms that pull data (single record) from the main tables and store local, rather than connect directly to the linked tables.
Saves would run upd query back to the main table.

[perryc]

8 meg is nothing.
compact frequently (backups too)
use unbound forms that pull data (single record) from the main tables and store local, rather than connect directly to the linked tables.
Saves would run upd query back to the main table.

I am wondering is this what you are referring to... it may be too complex for my little non-programmer's brain. But thanks. I really don't understand why pulling only 8MB data can be so slow over the network.

https://oakdome.com/programming/MSAc..._Forms_VBA.php