VB/Access problem

I have two PCs on there own little network - both running Windows 2000 with a VB6 front-end application accessing an Access 2000 database. The access database is on one of the PCs (I'll call it the master). When I run a my VB application it runs fine if I am only running on one of the PCs but if I run on both at the same time the performance on the PC without the Access database gets extremely slow, although the performance on the Master is still grand. Obviously some kind of resource sharing problems but am not sure where the problem is. can anybody help?

Hi,

In almost all cases of small networks and heavy degrading performance the cause is always found in poor network setup, topology or equipment. Only in rare cases it is caused by some piece of code or resource leak.

Things to check:

• What network equipment are we talking about? Coax? UTP with hubs at what speed?, WireLess?, Tokenring?
• What are the protocols that are running on the machines? Netbui, TCP/IP, Appletalk, IPX/SPX, LanMan, other exotic thingie?
• What networking cards (NIC) are being used (brand/type/speed) and have they been setup properly?
• How fast is a 5mb file transfer from machine A to machine B and vice-versa?
• How do you open the database (in code) with what settings (mode, locktype, options)?
• Does the order of starting the application yield other results? (master runs fast when started first, master runs slow when started second?)

If you could check those, you might discover something that is eating up your performance. If not, post the results here so we can analyse them.

Grtz.©

M.