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
(*.mdb); dbq=c:/misc/test1.mdb","admin","",{AutoCommit => 1 }) or die
"$DBI::errstr\n";
Here's the error:
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]
Record(s
) cannot be read; no read permission on 'MSysObjects'. (SQL-42000)(DBD:
st_execu
te/SQLExecute err=-1) at C:\misc\read_msaccess.pl line 19.
Cannot execute statement: [Microsoft][ODBC Microsoft Access Driver]
Record(s) ca
nnot be read; no read permission on 'MSysObjects'. (SQL-42000)(DBD:
st_execute/S
QLExecute err=-1) at C:\misc\read_msaccess.pl line
19.
Any ideas? Queries to user tables work fine, just not to System Objects.
Yes, the "System Objects" checkbox is checked in the "Options".
Jeff
> This e-mail and any files transmitted with it are property of Cingular
> Wireless, are confidential, and are intended solely for the use of the
> individual or entity to whom this e-mail is addressed. If you are not one
> of the named recipient(s) or otherwise have reason to believe that you
> have received this message in error, please notify the sender at
> 217-535-6404, and delete this message immediately from your computer. Any
> other use, retention, dissemination, forwarding, printing, or copying of
> this e-mail is strictly prohibited
>
>
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
