×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access Slow Down??

Access Slow Down??

Access Slow Down??

(OP)
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

RE: Access Slow Down??

(OP)
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.

RE: Access Slow Down??

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

RE: Access Slow Down??

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close