Hi all, I've been working on an inventory type program with a combination of ADODC and ADODB.Connection objects with local development database file. The purpose of ADODC is that I want to have an updatable data grid. ADODB conns are used to populate dropdowns and inserting new records. The back-end is Access 2000. When I moved into testing over to the file on the network, which is what they want, accessing becomes significantly slower 
So what is slowing me down and how to speed things up as much as possible? Should I try to elimiate ADODCs? I know Access is never meant to be a data server, but the users wants to stay with Access files. Thanks a million!
So what is slowing me down and how to speed things up as much as possible? Should I try to elimiate ADODCs? I know Access is never meant to be a data server, but the users wants to stay with Access files. Thanks a million!