Mysterious things happening with split database

[RoyS29]

I have a database that I split into code and tables. The tables reside on a
shared server. Each of over 100 users had a copy of the front end code file
on their own hard drive. Many of these users work from home, so who knows
how many routers/connections they go through to reach the server. I work
from head office and everything runs perfectly. Many users, especially with
slower connections, are having problems like tables not populating
completely, VB code not executing, random error messages stating a form
cannot be found, a field cannot be found, etc. Does anyone have experience
with this type of distributed application who could shed some light on these
problems?

Thanks in advance.

Roy Seifert

 

[Albert D. Kallal]

Well, I can't even imagine that users over these slow connections
are achieving ANY KIND OF reasonable performance.

First, YOU MUST split your application. There is some reading on this here
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Further. how can you NOT ASK what type of connections these people have?

here is some reading and solutions to your problem

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[Douglas J. Steele]

He said "Each of over 100 users had a copy of the front end code file on
their own hard drive", so it's already split. However, you're right that
they need to ensure better connections.

 

[RoyS29]

Albert, thank you for your response, although terse, and excellent articles.
This has definitely pointed me in the right direction. I am now in the
process of converting the backend tables and user front end to MDP files
using SQL Server.

Thanks again.