×
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

Multi-User Access Slows Badly

Multi-User Access Slows Badly

Multi-User Access Slows Badly

(OP)
I wonder if one of you Access Gurus can explain a slow down I just saw.

I am responsible for a simple Multi-User Access 2007 System at a non-profit Food Pantry. This Application is a split Database, where two Laptops at the front end (both running Front-End split software) communicate via wired, 1Gbps Ethernet to a Desktop that is acting as a Server and runs the Front-End split software. There is a 1Gbps Ethernet switch in the System to allow two Laptops to talk to one Desktop Ethernet port. This system runs surprisingly slowly from the two Laptops, normally taking about 20 seconds to pull up a large, multi-tab form. I have thought for a while that things might improve, if I could somehow manage "collisions" at the Back-End, as both laptops must frequently access the same two large tables in the Back-End. Unfortunately I do not know how to adjust that parameter.

I have just noticed that, when only one Laptop is logged into the Access Application, thing run 3-4 times faster. When the second Laptop is logged into the Application, things slow down to normal again for both laptops. Surprisingly, logging off the second Laptop again speeds things back up very little, if at all. Only rebooting the desktop and then logging only one Laptop into the Application speeds things back up again.

Would someone explain to me what is happening here? Is there any way to get the faster speed, when both Laptops are logged into the Application?

Thank you

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