Hi, I have a vb6 program who access an 97 access database.
everything works fine when I put the database files into the shared harddrive (we put it as Z:\)
It is running very very slow...
I dunno why is it happening, it works really fine if I put them in app.path in the single computer.
I put a lot of insert and update query though.. so it is very logical if it is getting slower.
What can I do to improve the speed? If I really need to update my database, please lead me where to go :(
thanks a lot