iamchemist
Programmer
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
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