I think you just need to set a reference to the DAO object library. In the VBE editor, select Tools-References, then enable the Microsoft DAO 3.6 Object Library. Tom
I know how to use the Common Dialog Control to select files of specific types. Is there a way to set up a dialog box like this where the user can select a FOLDER (with only folders displayed) and have the path to the folder saved?
Thanks,
Tom
The back end MDB gets compacted once every week. I was compacting the front end file whenever very many design changes were made, that is until I found that compacting the front end made things a lot slower.
Gino - Our server is located in the same building, and we typically do have a very fast network. In fact, earlier when the Forms, Tables, & other objects were all contained in a single file on this same server we did not have this problem.
Tom
I have a split Access 2000 database, the back end located on a network file server & front ends on individual PCs. After compacting/repairing or making design changes to front end form(s), they become very slow to load - some 2 minutes. If I copy & paste the form(s) onto a duplicate of the...