Low Performance Access with ODBC on NetWork

[Jose]

I'm using one DataGrid connected with an Access Data Base using an ODBC, when the Data Base is in my own computer the performance is good, but when the Data Base is in another computer on the NetWork the performance decrease (in about 8 seconds), My question is: is possible increase the performance with code or I have to modify the HardWare.

For information:
Visual Basic 6
Windows 98
Microsoft Network with TCP/IP Protocol
Access 97
Pentium II 400/Mhz
Table with 1270 records

That was the expacted problem....
Acces97 will not perform well when windows hang. The critical problem will happend someday that you cannot repair or compact your database.

In my case I face problem when windows severally hang and after 3 time repair (in 2 weeks time). suddenly cannot repair or compact even cannot see the table in Access97

I solve the problem using Access2000. In Access2000 i can view back my table and repair. the performace better then Access97, but you must import all the table. and must do a few adjustment on field (Make sure the property behave like Access97)

It is more efficent if you can chage the Database into paradox using ODBC connection. Superb fast. Espacilly for sql statement....

-Khamal-

[Clunietp]

With MS Access databases over the network, EVERY TIME you make a query or open a recordset, the ENTIRE TABLE must be transferred over the LAN to the client, then the client filters out what it needs.

If you have many thousands of records and have more than 5-10 users using this application, you'd probably want to get them a real RDBMS (like SQL server or Oracle, among others)

[JHausmann]

If you're using Access, create a local database that points to your network database (attached tables). This will help improve your "networking" issues.