Access XP messing up over slow network

  • Thread starter Thread starter Digital Carnage
  • Start date Start date
D

Digital Carnage

Hi Gang,
I have an Access 2002 database that I've saved to a server's I:\ drive
and created a shortcut to the database on my client's workstation. They've
had some real bad network bandwidth issues which is creating severe lag
times when using any of my forms or even just opening the database. Forms
that worked just fine before and have not been altered are now return VB
error messages, returning false or no data to subforms and more. Is this a
common occurance for Access when response times are lagging over 1 minute or
more? Thanks Rich
 
It would be far nicer if you would at least cross post and not multi-post to
each newsgroup.

How are we (or you for that matter) going to know when others in other
newsgroups has already responded to your question? People don't take too
kindly to having their time wasted here!

For issues of connection performance, you want to check out:

http://www.granite.ab.ca/access/performancefaq.htm


Also...if you plan to have more then one user on the system, then you want
to use a split database arrangement. This also allows you to develop your
software in a far more controlled fashion.

For info on splitting..check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm


Also, you are talking about a typical office network (a lan), and surely are
not talking about a wan...are you? You did ask how fast the network
is...right?

If you need information on connecting ms-access via a wan (wide area
network), then you can read the following article of mine:

http://www.attcanada.net/~kallal.msn/Wan/Wans.html
 
Back
Top