Linked Tables dropping connections over a network

  • Thread starter Thread starter Wayne B. Jackson
  • Start date Start date
W

Wayne B. Jackson

Thanks, for reviewing my question. I have a medium size
database application that is used by between 4 to 6
people. Originally, the application resided on a network
server. As the quantity of data grew, I wanted to speed up
the application's response time across the network by
slitting the database. Now, only the tables reside on the
server and the front end sits on each individual
workstation. For some reason, that I have not been able to
figure out, the network link between the back-end tables
and front-end application drops continually. After
working in the application for a short while, the front-
end is unable to fine the back-end tables. I end up having
to manually re-link the tables through the 'Linked table
manager'. Have you ever heard of this problem? Could you
share some understanding as to why the link over the
network constantly drops, and your recommendations on how
to resolve this problem? (Of course this front-end / back-
end application never looses its connection when front-end
and back-end reside on the same machine.)

Thanks and Good Access to you!

Wayne Jackson
 
Wayne B. Jackson said:
Thanks, for reviewing my question. I have a medium size
database application that is used by between 4 to 6
people. Originally, the application resided on a network
server. As the quantity of data grew, I wanted to speed up
the application's response time across the network by
slitting the database. Now, only the tables reside on the
server and the front end sits on each individual
workstation. For some reason, that I have not been able to
figure out, the network link between the back-end tables
and front-end application drops continually. After
working in the application for a short while, the front-
end is unable to fine the back-end tables. I end up having
to manually re-link the tables through the 'Linked table
manager'. Have you ever heard of this problem? Could you
share some understanding as to why the link over the
network constantly drops, and your recommendations on how
to resolve this problem? (Of course this front-end / back-
end application never looses its connection when front-end
and back-end reside on the same machine.)
Click to expand...

This sounds very much like a network inactivity setting. I'd start
asking questions of the network admins.

You might also want to consider kicking users out after a certain
period of inactivity. Say an hour or so.

HOW TO: Detect User Idle Time or Inactivity in Access 2000 (Q210297)
http://support.microsoft.com/?kbid=210297
ACC: How to Detect User Idle Time or Inactivity (Q128814)
http://support.microsoft.com/?kbid=128814

However we found that the code which runs on the timer event must be
disabled for the programmers. Otherwise weird things start happening
when you're editing code.

Also print preview would sometimes not allow the users to run a menu
item to export the report to Excel or others. So you had to right
click on the Previewed report to get some type of internal focus back
on the report so they could then export it. This was also helped by
extending the timer to five minutes.

The downside to extending the timer to five minutes was if a person
stays in the same form and at the same control for considerable parts
of the day, ie someone doing the same inquiries, the routine didn't
realize that they had actually done something. I'll be putting in
some logic sometime to reset this timer whenever they do something in
the program.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top