The FileDialog object is not available in Access 2000.
You can find code to open a file/save dialog at
I have Access 2002 on my machine.
tried it on the Northwind.mdb (also Access 2000 file format). However when
I copy this function into the client's file and tried to execute it, I get
this error "Compile error: User-defined type not defined" and this line code
is highlighted "...fDialog As Office.FileDialog"
is selected. I have to create a form with the Open FIle Dialog to allow a
user to pick a *.mdb file and then the code will do a Open DB on this *.mdb
file, read in records from one of the tables and append the new records to a