Printable View
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
Welcome to VBForums :wave:
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?
Hi,
I wont get back in to work till tuesday. I'll give more details then
An access dataset object is dragged on to the form.
Is this the right way?
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.