note
richardX
One tip for making large strings and <b>memo fields</b> work better with Access is to use the following code:
<code>
my $dbh = DBI->connect( "dbi:ODBC:home", "", "",
{RaiseError => 1, PrintError => 1, AutoCommit => 1} ) or
die "Unable to connect: " . $DBI::errstr . "\n";
$dbh->{LongReadLen} = 20000 ; # to better handle long variables
</code>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-192095">
<P>Richard <BR><BR>
There are three types of people in this world, those that can count and those that cannot. Anon
</div></div>
444859
444859