Ok, Access Wizards!!!! (1 Viewer)

[merciless32]

I have several databases that I am monitoring. I need to create another database that combines a table (Answers), from each of them quickly. I need a search feature on a form wherein I can type the database name, and have access import the 'Answers' table from that specified mdb. Any suggestions?

 

[JMS]

I would generate an HTML index using QueryWeb (www.query-web.com). It can be regenerated automatically and you don't need an extra .mdb. This tool is really powerful once you get into it, but you need to know how to write real SQL code.

I am not so experienced but I can't think of a simple way to do this with Access.