RE: Getting Tables in MS Access DB

2002-12-26 Thread Jeff Urlwin
> > > Using a DBI:ODBC DSN-less connection to an Access DB( Access > 2000 ), how do I get the the names of all tables contained in > the DB? I tried to query MSysObjects, but I'm getting a > permission's error. Try using the tables() method -- however, that results in a direct call to SQLTa

Getting Tables in MS Access DB

2002-12-26 Thread MOTTER, JEFFREY D.
Using a DBI:ODBC DSN-less connection to an Access DB( Access 2000 ), how do I get the the names of all tables contained in the DB? I tried to query MSysObjects, but I'm getting a permission's error. Here's my connect string: my $dbh = DBI->connect("dbi:ODBC:driver=Microsoft Access Driver