Re: How to I force ADO to release locks


<clatonhendricks@xxxxxxxxx> wrote in message
news:1171416936.300561.53790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am working in Acc2003 and I need to know How I can force ADO to
release locks before executing a SQL statement.....

Any kind of help is appreciated...

Regards,
Claton


This post is essentially context-free. ADO doesn't have anything to do with
"locks" except to provide interfaces to various objects allowing you to set
various "locking attributes".

Perhaps, you mean you want to use ADO to release locks setup by the engine?
The simplest answer is you can't. If there are 'locks' it is because either
the engine is enforcing some integrity rule, or because you requested them
thru some previous query or object creation.

Why not provide a few more details concerning what you are trying to do and
why current locking behavior is an impediment to your plan. - Likely another
solution is available.

-ralph


.

Relevant Pages

  • AddNew of float-values in oracle database will lock the record
    ... inserting new values in an oracle database via ado, ... as long as I don't add float values which are rounded: ... roundworks finde, roundlocks the ...
    (microsoft.public.data.ado)
  • Re: DAO recordset append single record locks entire table (linked table)
    ... I tried DAO, ADO, recordset & SQL statements but still locks the table! ...
    (comp.databases.ms-access)
  • Re: Fuel use
    ... So I can give some vaguely useful figures - a total of 213 miles and 148 ... So that suggests about 2 miles a litre, and given the speed and the ... locks I'd say 1 litre an hour (CanalplanAC estimates 106 hours for the ... less because no doubt your engine runs more ...
    (uk.rec.waterways)
  • Re: Fuel use
    ... So I can give some vaguely useful figures - a total of 213 miles and 148 ... So that suggests about 2 miles a litre, and given the speed and the ... locks I'd say 1 litre an hour (CanalplanAC estimates 106 hours for the ... But would you expect to use more because of the larger engine, ...
    (uk.rec.waterways)
  • Re: 2001 L200 -- set locks not to open automatically
    ... Why don't you just call the dealer and ask over the phone? ... locks all open up when I shut off the engine. ... invitations to discover the universes of musicians and artists ...
    (rec.autos.makers.saturn)