Error message SQL another user are attempting to change the same data
I have a system script that updates a SQL database which emails out any errors to me.
Recently the server where the SQL is hosted has been moved, the new server was working well for a week. Then I added a couple of fields into SQL and the system script which worked for a day but then I started getting constant emails, like 50 in 3 minutes, with the below error:
Status: LNVF Error Number: LNVF00007 Source: DAO.Recordset Number: 3197 Description: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Any ideas how i can resolve?
sql-server sql robots.txt
edited Jan 21 at 13:09
Blackwood
2,88671728
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
add a comment |
I have a system script that updates a SQL database which emails out any errors to me.
Recently the server where the SQL is hosted has been moved, the new server was working well for a week. Then I added a couple of fields into SQL and the system script which worked for a day but then I started getting constant emails, like 50 in 3 minutes, with the below error:
Status: LNVF Error Number: LNVF00007 Source: DAO.Recordset Number: 3197 Description: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Any ideas how i can resolve?
sql-server sql robots.txt
edited Jan 21 at 13:09
Blackwood
2,88671728
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
add a comment |
I have a system script that updates a SQL database which emails out any errors to me.
Recently the server where the SQL is hosted has been moved, the new server was working well for a week. Then I added a couple of fields into SQL and the system script which worked for a day but then I started getting constant emails, like 50 in 3 minutes, with the below error:
Status: LNVF Error Number: LNVF00007 Source: DAO.Recordset Number: 3197 Description: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Any ideas how i can resolve?
sql-server sql robots.txt
edited Jan 21 at 13:09
Blackwood
2,88671728
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
I have a system script that updates a SQL database which emails out any errors to me.
Recently the server where the SQL is hosted has been moved, the new server was working well for a week. Then I added a couple of fields into SQL and the system script which worked for a day but then I started getting constant emails, like 50 in 3 minutes, with the below error:
Status: LNVF Error Number: LNVF00007 Source: DAO.Recordset Number: 3197 Description: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Any ideas how i can resolve?
sql-server sql robots.txt
sql-server sql robots.txt
edited Jan 21 at 13:09
Blackwood
2,88671728
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
edited Jan 21 at 13:09
Blackwood
2,88671728
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
edited Jan 21 at 13:09
Blackwood
2,88671728
edited Jan 21 at 13:09
Blackwood
2,88671728
edited Jan 21 at 13:09
Blackwood
2,88671728
2,88671728
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
asked Jan 21 at 12:40
Lewis WilliamsLewis Williams
12
12
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1396605%2ferror-message-sql-another-user-are-attempting-to-change-the-same-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1396605%2ferror-message-sql-another-user-are-attempting-to-change-the-same-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
