You can't, maybe with an OLEDB module. The settings should be made directly
in the database and then everyconnection will automatically use them. Not
sure, but there are probably ways to set different locking levels based on
the user id, etc...
Ilya Sterin
-----Original Message-----
From: David Billingham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 4:49 PM
To: Sterin, Ilya; [EMAIL PROTECTED]
Subject: Re: Locking via DBI
Hi
Thanks for your reply.
> This is usually implemented by your DB package. Access has table and
record
> locking ability so you must read the docs to implement this on the access
> side.
Sure - but I don't understand how to get at this functionaility via
Perl\DBI. Is there a standard ODBC way to do this - I've searched, but can't
find it?
Thanks
David Billingham
> Ilya Sterin
>
> -----Original Message-----
> From: David Billingham
> To: [EMAIL PROTECTED]
> Sent: 3/22/01 10:55 AM
> Subject: Locking via DBI
>
> Hi
>
> Can anyone tell me how to lock tables\recordsets via the DBI interface -
> or
> tell me where I should be looking for this info.
>
> I am using DBD:ADO to connect to an Access database on an NT server.
>
> Thanks in advance.
>
> David Billingham
>
