The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

DBIx::Class::Storage::DBI::ACCESS - Support specific to MS Access

DESCRIPTION

This is the base class for Microsoft Access support.

This driver supports last_insert_id, empty inserts for tables with AUTOINCREMENT columns, nested transactions via auto_savepoint, GUID columns via DBIx::Class::Storage::DBI::UniqueIdentifier.

SUPPORTED VERSIONS

This module has currently only been tested on MS Access 2010.

Information about how well it works on different version of MS Access is welcome (write the mailing list, or submit a ticket to RT if you find bugs.)

USING GUID COLUMNS

If you have GUID PKs or other GUID columns with auto_nextval you will need to set a new_guid callback, like so:

$schema->storage->new_guid(sub { Data::GUID->new->as_string });

Under Catalyst you can use code similar to this in your Catalyst::Model::DBIC::Schema Model.pm:

after BUILD => sub {
  my $self = shift;
  $self->storage->new_guid(sub { Data::GUID->new->as_string });
};

FURTHER QUESTIONS?

Check the list of additional DBIC resources.

COPYRIGHT AND LICENSE

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.