Access Slow Down??

[iamchemist]

You guys have heard this scenario before. I am running a split Access 2007 Database at a non-profit Food Pantry. There are 2 Laptops running the Front End Database part connected by wired Ethernet to a Desktop running the Background Database Part.

We have recently simplified the Ethernet wiring and changed everything to CAT 7 Ethernet Cable to help speed things up a bit.

I have noticed that the Database runs about 40% faster either immediately after starting the Front End Database or immediately after Repair and Compact of the Database. Once a few Clients have been looked up in the Front End Database (using major Tables located in the Back End Database), then things slow down drastically again. For much of this slow-down time. Access is putting a message at the top of the screen that says that the Back End Database is not responding.

It seems that a significantly faster speed is just out of reach. Does anyone have any idea what is going on here.

Thanks,

Ron

 

[iamchemist]

I assume that, based on the scenario I outlined, no one has any ideas about what is going on.

Could someone tell me if this might be a memory issue with the Desktop (acting as a server) computer? For example, if one of the two users out of two logs out of the Front End Database, then does Access free up some memory on the Desktop Back End Computer? If so, that might explain why when one of multiple users logs off and then back on again, things speed up for that user on the next search they do. After they do one or two searches, then things slow back down again.

 

[Moss100]

Does each computer have its own copy of the front end locally or are they all sharing the same front end?

 

[iamchemist]

Yes, each of the two Laptops have their own copy of the Front End Database. Of course, only one Laptop was used in splitting the Database. The resulting Front End Database was copied to the other Laptop. That other Laptop's Front End Database seemed to utilize the Back-End Database with no problem.