Re: Error => -2147467259 Could not save; currently locked by another
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 13 Nov 2007 07:13:31 -0500
Mike wrote:
Hi,I don't work with Jet backends anymore, and even when I did I avoided Memo
I am using VB 6 with Sp6 (XP sp2), Jet 4.0 and Access database.
I have one table it has Memo field and I am trying to save Memo filed
that time it gives me error
"-2147467259 Could not save; currently locked by another user."
While adding new records with same number of character is fine (more
than 3000 Characters).
Here is the sample code
Private Sub Command2_Click()
Dim ssql As String
Dim cnn As New ADODB.Connection
cnn.Open gCnnstring
ssql = "UPDATE Test_Memo SET Comment =" & Chr(34) &
Trim(TxtInput) & Chr(34)
ssql = ssql & " WHERE Record_ID=" & mRecordID
cnn.Execute ssql
cnn.Close
End Sub
fields, so I've never encountered this situation. The only time I've ever
seen the error you cited was when insufficient file-system permissions for
the folder containing the database were granted to the user of the database.
All database users required Modify (read/write) permissions for that folder
because they need to create, modify and delete the database locking file
(dbname.ldb) in that folder.
If that's not the case and you fail to get help here, you should post to one
of the Access newsgroups (look under "Office Solutions" in the table of
contents).
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Prev by Date: Re: How to create a temporary Primary Index for an ADO recordset
- Next by Date: Re: How can i get the "true" name of an aliased field?
- Previous by thread: How can i get the new vaule of a counter field?
- Next by thread: Re: Error => -2147467259 Could not save; currently locked by ano
- Index(es):
Relevant Pages
|
|
