--- Mark Wieder <[EMAIL PROTECTED]> wrote: > Jan- > > Tuesday, January 27, 2004, 2:01:48 AM, you wrote: > > The only way I know of to get a list of tables from > MSAccess with a > direct SQL statement is: > > SELECT * from MSysObjects where type=6; > > -- > -Mark Wieder >
Thanks Mark -- if anyone else knows similar SQL statements for other databases than MySQL, Oracle, Valentina and now Access : don't hesitate to post them to the list or email them to me directly :-) Jan Schenkel. ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution