Re: DAO recordset append single record locks entire table (linked table)

Unfortunately using the SQL INSERT statement also locks the entire
table..

I tried DAO, ADO, recordset & SQL statements but still locks the table!

Is it something to do with JET & linked tables? I'm testing the code
with both front-end & back-end on the same PC.

.

Relevant Pages

  • Re: Relationship Question
    ... I've used your SQL statements by passing them into an connection.Execute ... statement in ado. ... CONSTRAINT master_cannot_be_slave ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL string problem
    ... >event to create a recordset in VBA and then set the forms ... I don't have any SQL statements as ... >Dim StrSQL As String ... >Dim rst As DAO.Recordset ...
    (microsoft.public.access.queries)
  • RE: Synchronize Combo Box and Text Box
    ... The SELECT statement is to build a recordset. ... need apostrophe delimiters for text in SQL statements. ... Private Sub Combo8_AfterUpdate ... I’ve done this sync using two Combo Boxes, is it not possible to sync a Text ...
    (microsoft.public.access.formscoding)
  • Re: sql share lock issue
    ... cursor or try a movelast against the recordset. ... The problem lies with either ODBC or SQL server. ... >of various types of locks on one of the tables. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Print all open docs
    ... Thanks for the pointers Malcolm. ... sql statements in access, and printing all docs and automating MSWord ... you have a RecordSet object. ... >table or to a Query. ...
    (microsoft.public.word.vba.general)