I have many microsoft access database and saved under file name like 4945.mdb, 4946.mdb, 4947.mdb etc..
Inside each *.mdb, there are data columns like Serial Number, Part Number, Qty etc.
Let say I want to create a Query using VB to search one of the Part Number in all these *.mdb files, may I know how to create it?