I've created a small database (10 Mb) , placed the data part on a WIN 2003 server (2.4 GHz, 1024 MB Ram, network 100Mb/s), the forms and code placed on the desktop (Client: Win XP prof. 2.4GHz, 1024 Mb Ram)
The data is linked with the client using the link option available in Access. All the VBA code written in DAO,....
Problem: If we run this datase (client / server) it takes a lot of time before a small recordset, query, ... retrieves some data, running both the databases on the client site, its extreme fast !!
Does anyone have a solution ??
I've created this database with Office 2003
Thanks for your help!