Advertisement

07.23.2008 at 02:14AM PDT, ID: 23587777
[x]
Attachment Details

Error when more than one person is in the database and the save button is clicked.

Asked by james252 in Microsoft Access Database

Tags: Microsoft, Access, 2003, Run-time error '2501' The Save action was cancelled.

When more than one person is in the database, data can't be saved. It appears that the database is shared without locks. The debug takes me to the code snippet attached and highlights the first DoCmd.Save action. This is not my code but appears to be a sort of 2nd chance before saving data.
Can anyone help?
JStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

Private Sub Form_BeforeUpdate(Cancel As Integer)
 
    If MsgBox("Are you sure you want to save?", vbYesNo + vbInformation) = vbYes Then
 
        DoCmd.Save acForm, "frmBPREdit"
        MsgBox "Your changes have been saved!  ", vbInformation
        Check = 1
                    
    Else
           
        Exit Sub
        MsgBox "No changes have been recorded!  ", vbInformation
        DoCmd.Close acForm, "frmBPREdit", acSaveNo
    
    End If
 
End Sub
 
Keywords: Error when more than one person is in …
Title
1 What can I do to make Microstation J ru…
2 Docmd.Save
3 Highlight msflexgrid row and copy to m…
4 VBA Code snippet
5 Several VBA snippets
6 Stored Procedure debugging
 
Loading Advertisement...
 
[+][-]07.23.2008 at 02:41AM PDT, ID: 22067416

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 02:48AM PDT, ID: 22067447

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:11AM PDT, ID: 22067553

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:20AM PDT, ID: 22067595

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:32AM PDT, ID: 22067647

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 03:56AM PDT, ID: 22067780

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 04:19AM PDT, ID: 22067886

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 04:26AM PDT, ID: 22067919

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 04:43AM PDT, ID: 22068019

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 06:15AM PDT, ID: 22068935

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: Microsoft, Access, 2003, Run-time error '2501' The Save action was cancelled.
Sign Up Now!
Solution Provided By: peter57r
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628