Multiple DB Access

[stench]

Hello everyone, I am creating an ODBC connection to a database on another machine using Visual Basic and an Access MDB, however, when I do that, my program slows down to a crawl when accessing the DB.

If I access a database on the local machine, it works fine. I've tried it on different computers on different networks and always run into this issue.

Has anyone done this successfully? Are there any ODBC parameters or buffer settings that I need to set.

Basically all I need to do is access an mdb on a shared Win98 folder from two different machines.

Thanks alot!!!

Chris.

 

[Cagliostro]

First advice, use PassThrough queries.
Second advice, don't use Access databases. SQLServer, MySQL are very good. By the way, MySQL is freeware. John Fill

ivfmd@mail.md

 

[tlbroadbent]

I don't beleive the issue is ODBC. The likely issue is sharing across a network, especially from a Win98 share. You'll get better performance if the shared database resided on a network server.

If you must use the Win98 share, make sure you compact the database frequently. You might experiment with some ODBC settings such as MaxBufferSize to see if you can improve performance.

Good luck. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[stench]

Thanks everyone for your replies. I see now that using Access in this situation probably isn't a good idea. I did find that accessing the database from an NT machine worked much better than from a Win98 machine.

Thanks again,
Chris.