MS SQL through MS Access using DBI:ODBC

[Ian Summers]

Hi

When connecting an MS SQL database from MS Access it is necessary to use 
the option dbSeeChanges with db.openrecordset. This is ok when using Visual 
Basic but is it possible to access the data using DBI:ODBC.

        Win2000
        MS SQL version 7
        MS Access 97
        perl 5.005 (build 509)
        W32ODBC.pm,v 10.1 1998/08/14

Thanks.

Ian