Slow DB access

[stench]

Hello everyone, I'm experiencing extremely slow database access when accessing it through a Win98 share on another machine.

I'm using Visual Basic 6 and an Access Database which runs fine when the database is on the local machine, but slows to a crawl when accessing it through a share from another machine. The database isn't that big and the second computer is on the same
network, so I don't think the queries should take that long.

I've experienced this on several different machines on separate networks, so it's not a network or PC problem.

Is what I'm trying to do a good idea? Is there something else I should be doing to speed it up?

Any replies or suggestions are much appreciated...

Chris.

 

[scking]

The following would speed up access to your database.

1) Split the database into the user interface (client) and the data (server).
2) Place the data on a network accessable drive and link the data tables to the client.

This will, at least, reduce overhead associated with using the Windows share drive and having the entire user interface being transfered over the network.

Steve King Growth follows a healthy professional curiosity