in reply to How to link Ms-access data's in perl

One tip for making large strings and memo fields work better with Access is to use the following 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

[download]

Richard

There are three types of people in this world, those that can count and those that cannot. Anon

In Section Seekers of Perl Wisdom