lspeed430 - this might be a bit too obvious but doesn't the fact that you close the database before executing the search mean that Jet doesn't know where to look for the tables ? Does making the Database object a module level var solve the problem ?

I don't know if you've included all the code but if you have then that's your problem.