selecting list of tables from database

Ravindah,

I am not exactly sure what you are wish to do with the tables, but the following sites should point you in the right direction for the correct code to achieve your objective.

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/700/qid/742688

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/ac...

Hope they are of some help.

Regards

Julie
www.simply-access.com