Please guide me!

[Ken_Lee]

I'm currently encountered a problem now with database, we plan to use Data Source to access the data from the database. E.g. we put the database file (*.mdb) into a NT server and we placed the application program into the client computer of that server Or we can said that we access the database in the server by using the program, which is installed in the client computer. After my studying, I find that "Remote Data Object" -> RDO or "ActiveX Data Object -> ADO should be used. I try out the components both the ADODC and DATAGRID by setting the connection properties to the Specified Data Source Name in the Control Panel of Windows and Record Source properties by using SQL command but I find it very slow even I just have 8 thousands over records. Have I used the RDO and ADO the right way? or may be there is some trick to access data fast. Can you please provided together with some actual examples (Note: we're not planned to use the fixed path of the database and the indexing methods such as APP.PATH or DYNASET). Anyway, thanks for looking into my Serious problem here and wish you have a nice day.

[jp-mattenet]

Some suggestions:
Is Your application (client) accessing the mdb in a shared drive?
If that is the case try creating another mdb, that have links to the server mdb, and place a copy of that mdb on each client.
Connect you appliation to the local mdb...

Check the index / Sql that take the longer to execute, performance can improbed by adding some indexes.

Move tables that are not updated frecuently to the local copy of the mdb.

And remember mdb databases are no good for more than 5 (IMHE) conncurent users. If you plan for a larger number of users then a different database like MS-SQL or Oracle should be considered.

Hope it helps,
JP

Juan Pablo Mattenet