Sharing access db slow when sharing

[dBase4]

Hi all
Maybe this has been covered elsewhere but I have been unable to find any info

I am using VB6 with latetest service pack.
The access files stored on an XP pro "server"
The vb application is on PC A pointing to "server" via network share for the datafiles
.
Everything is slick and fast with just PC A using the database. But when I use the same application on PC B as well the whole lot starts running slow

Any suggestions would be appreciated

regard

[si_the_geek]

Welcome to VBForums

Just two connections shouldn't be a problem (you can have about 5 to an Access database without noticable issues), so presumably it would be a problem with the code/controls you are using.

Could you tell us a bit more about how you are connecting to/using the database?

[dBase4]

Hi,
I wont get back in to work till tuesday. I'll give more details then

[dBase4]

An access dataset object is dragged on to the form.
Is this the right way?

[si_the_geek]

Do you mean that you have a Data control (which by default is called Data1 or ADODC1)?

If so, I would stringly recommend against it for a variety of reasons (see the "bound controls are bad" article in our Database FAQs), and recommend using ADO code instead - for an example of how to do this, see the ADO Tutorial link in my signature.

Doing this allows you to specify which locking methods should be used, which should significantly improve multi-user performance.