Microsoft Access Database is in an inconsistent state
We have a client that uses our MS Acccess based software, they are up to
20 users working on the front end at the same time.
Each user has its own .mde front end and the backend database is a .accdb...
My question is why only this clients database keeps getting corrupted or in an "inconsistent state". None of our other clients expierence this problem.
Any tips or advice?
ms-access
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
add a comment |
We have a client that uses our MS Acccess based software, they are up to
20 users working on the front end at the same time.
Each user has its own .mde front end and the backend database is a .accdb...
My question is why only this clients database keeps getting corrupted or in an "inconsistent state". None of our other clients expierence this problem.
Any tips or advice?
ms-access
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
It might be, that one or more workstations are connected via WiFi.
– Gustav
Nov 23 '18 at 7:24
Because you ask for a tip also: I suppose you already know this, but in this scenario you should really switch to a SQL Server as backend, especially since the Express version is free after all. Furthermore, I have seen anti-virus software, which monitor network traffic, do the craziest effects already.
– Unhandled Exception
Nov 23 '18 at 8:56
This has nothing to do with VBA or coding - the question is off-topic on Stack Overflow and should be asked in another venue, such as Super User.
– Cindy Meister
Nov 23 '18 at 11:29
I would also check the table structure for any memo fields. Those typically cause corruption. I found a recent article that related some corruption to certain builds of Windows 10 as well. Check to see that you don't use mde with Office 365, as that can cause a problem, and eliminate as many memo fields as possible.
– Destin Consulting
Feb 2 at 5:52
add a comment |
We have a client that uses our MS Acccess based software, they are up to
20 users working on the front end at the same time.
Each user has its own .mde front end and the backend database is a .accdb...
My question is why only this clients database keeps getting corrupted or in an "inconsistent state". None of our other clients expierence this problem.
Any tips or advice?
ms-access
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
We have a client that uses our MS Acccess based software, they are up to
20 users working on the front end at the same time.
Each user has its own .mde front end and the backend database is a .accdb...
My question is why only this clients database keeps getting corrupted or in an "inconsistent state". None of our other clients expierence this problem.
Any tips or advice?
ms-access
ms-access
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
edited Nov 23 '18 at 11:29
Cindy Meister
15.8k102437
15.8k102437
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
asked Nov 23 '18 at 6:53
Festiis007Festiis007
1
1
It might be, that one or more workstations are connected via WiFi.
– Gustav
Nov 23 '18 at 7:24
Because you ask for a tip also: I suppose you already know this, but in this scenario you should really switch to a SQL Server as backend, especially since the Express version is free after all. Furthermore, I have seen anti-virus software, which monitor network traffic, do the craziest effects already.
– Unhandled Exception
Nov 23 '18 at 8:56
This has nothing to do with VBA or coding - the question is off-topic on Stack Overflow and should be asked in another venue, such as Super User.
– Cindy Meister
Nov 23 '18 at 11:29
I would also check the table structure for any memo fields. Those typically cause corruption. I found a recent article that related some corruption to certain builds of Windows 10 as well. Check to see that you don't use mde with Office 365, as that can cause a problem, and eliminate as many memo fields as possible.
– Destin Consulting
Feb 2 at 5:52
add a comment |
It might be, that one or more workstations are connected via WiFi.
– Gustav
Nov 23 '18 at 7:24
Because you ask for a tip also: I suppose you already know this, but in this scenario you should really switch to a SQL Server as backend, especially since the Express version is free after all. Furthermore, I have seen anti-virus software, which monitor network traffic, do the craziest effects already.
– Unhandled Exception
Nov 23 '18 at 8:56
This has nothing to do with VBA or coding - the question is off-topic on Stack Overflow and should be asked in another venue, such as Super User.
– Cindy Meister
Nov 23 '18 at 11:29
I would also check the table structure for any memo fields. Those typically cause corruption. I found a recent article that related some corruption to certain builds of Windows 10 as well. Check to see that you don't use mde with Office 365, as that can cause a problem, and eliminate as many memo fields as possible.
– Destin Consulting
Feb 2 at 5:52
It might be, that one or more workstations are connected via WiFi.
– Gustav
Nov 23 '18 at 7:24
It might be, that one or more workstations are connected via WiFi.
– Gustav
Nov 23 '18 at 7:24
Because you ask for a tip also: I suppose you already know this, but in this scenario you should really switch to a SQL Server as backend, especially since the Express version is free after all. Furthermore, I have seen anti-virus software, which monitor network traffic, do the craziest effects already.
– Unhandled Exception
Nov 23 '18 at 8:56
Because you ask for a tip also: I suppose you already know this, but in this scenario you should really switch to a SQL Server as backend, especially since the Express version is free after all. Furthermore, I have seen anti-virus software, which monitor network traffic, do the craziest effects already.
– Unhandled Exception
Nov 23 '18 at 8:56
This has nothing to do with VBA or coding - the question is off-topic on Stack Overflow and should be asked in another venue, such as Super User.
– Cindy Meister
Nov 23 '18 at 11:29
This has nothing to do with VBA or coding - the question is off-topic on Stack Overflow and should be asked in another venue, such as Super User.
– Cindy Meister
Nov 23 '18 at 11:29
I would also check the table structure for any memo fields. Those typically cause corruption. I found a recent article that related some corruption to certain builds of Windows 10 as well. Check to see that you don't use mde with Office 365, as that can cause a problem, and eliminate as many memo fields as possible.
– Destin Consulting
Feb 2 at 5:52
I would also check the table structure for any memo fields. Those typically cause corruption. I found a recent article that related some corruption to certain builds of Windows 10 as well. Check to see that you don't use mde with Office 365, as that can cause a problem, and eliminate as many memo fields as possible.
– Destin Consulting
Feb 2 at 5:52
add a comment |
2 Answers
2
active
oldest
votes
Depending on the version of the OS and the version of Access being used the mde file may not run properly. If they have a 64-bit version of access, and the mde was compiled in a 32-bit version, it may not be recognized correctly, but a accdb file would work fine, and you could lock it out as well.
Also, if your using an accdb back end, and need to use a compiled front-end, switch to using accde front-ends instead, as those are the modern compiled versions and mde should only be used in versions of Access prior to 2007.
My only question for you is to find out if the users are running from a network location or a local folder - as running any Access DB front-end from a network location can cause issues. Have the accde file (or the front end) copied to their desktop first, then run from there.
Also, after download, you can run a file size verification to confirm the whole file was downloaded, as I have seen wifi connections lose part of the file during download, and then that causes corruption too. If possible, split the interface into multiple, smaller files, to make the download more reliable.
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
add a comment |
It is also possible that this 1 client uses your app differently than you expect. Users are after all the ultimate debuggers.
Any table that has a primary key that is not an autonumber - is a candidate to be the cause in a multi user application should it be possible that multiple persons initiate a new record without entering the primary key value immediately....or even a single user that initiates a new record but does not complete the act entirely and leaves the PK field blank.
Other: although one can copy a back end file during use without affecting it - there may be some well-intended server functions that auto duplicate/copy/exchange files that may be the cause.
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53441907%2fmicrosoft-access-database-is-in-an-inconsistent-state%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Depending on the version of the OS and the version of Access being used the mde file may not run properly. If they have a 64-bit version of access, and the mde was compiled in a 32-bit version, it may not be recognized correctly, but a accdb file would work fine, and you could lock it out as well.
Also, if your using an accdb back end, and need to use a compiled front-end, switch to using accde front-ends instead, as those are the modern compiled versions and mde should only be used in versions of Access prior to 2007.
My only question for you is to find out if the users are running from a network location or a local folder - as running any Access DB front-end from a network location can cause issues. Have the accde file (or the front end) copied to their desktop first, then run from there.
Also, after download, you can run a file size verification to confirm the whole file was downloaded, as I have seen wifi connections lose part of the file during download, and then that causes corruption too. If possible, split the interface into multiple, smaller files, to make the download more reliable.
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
add a comment |
Depending on the version of the OS and the version of Access being used the mde file may not run properly. If they have a 64-bit version of access, and the mde was compiled in a 32-bit version, it may not be recognized correctly, but a accdb file would work fine, and you could lock it out as well.
Also, if your using an accdb back end, and need to use a compiled front-end, switch to using accde front-ends instead, as those are the modern compiled versions and mde should only be used in versions of Access prior to 2007.
My only question for you is to find out if the users are running from a network location or a local folder - as running any Access DB front-end from a network location can cause issues. Have the accde file (or the front end) copied to their desktop first, then run from there.
Also, after download, you can run a file size verification to confirm the whole file was downloaded, as I have seen wifi connections lose part of the file during download, and then that causes corruption too. If possible, split the interface into multiple, smaller files, to make the download more reliable.
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
add a comment |
Depending on the version of the OS and the version of Access being used the mde file may not run properly. If they have a 64-bit version of access, and the mde was compiled in a 32-bit version, it may not be recognized correctly, but a accdb file would work fine, and you could lock it out as well.
Also, if your using an accdb back end, and need to use a compiled front-end, switch to using accde front-ends instead, as those are the modern compiled versions and mde should only be used in versions of Access prior to 2007.
My only question for you is to find out if the users are running from a network location or a local folder - as running any Access DB front-end from a network location can cause issues. Have the accde file (or the front end) copied to their desktop first, then run from there.
Also, after download, you can run a file size verification to confirm the whole file was downloaded, as I have seen wifi connections lose part of the file during download, and then that causes corruption too. If possible, split the interface into multiple, smaller files, to make the download more reliable.
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
Depending on the version of the OS and the version of Access being used the mde file may not run properly. If they have a 64-bit version of access, and the mde was compiled in a 32-bit version, it may not be recognized correctly, but a accdb file would work fine, and you could lock it out as well.
Also, if your using an accdb back end, and need to use a compiled front-end, switch to using accde front-ends instead, as those are the modern compiled versions and mde should only be used in versions of Access prior to 2007.
My only question for you is to find out if the users are running from a network location or a local folder - as running any Access DB front-end from a network location can cause issues. Have the accde file (or the front end) copied to their desktop first, then run from there.
Also, after download, you can run a file size verification to confirm the whole file was downloaded, as I have seen wifi connections lose part of the file during download, and then that causes corruption too. If possible, split the interface into multiple, smaller files, to make the download more reliable.
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
answered Nov 23 '18 at 14:55
Destin ConsultingDestin Consulting
765
765
add a comment |
add a comment |
It is also possible that this 1 client uses your app differently than you expect. Users are after all the ultimate debuggers.
Any table that has a primary key that is not an autonumber - is a candidate to be the cause in a multi user application should it be possible that multiple persons initiate a new record without entering the primary key value immediately....or even a single user that initiates a new record but does not complete the act entirely and leaves the PK field blank.
Other: although one can copy a back end file during use without affecting it - there may be some well-intended server functions that auto duplicate/copy/exchange files that may be the cause.
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
add a comment |
It is also possible that this 1 client uses your app differently than you expect. Users are after all the ultimate debuggers.
Any table that has a primary key that is not an autonumber - is a candidate to be the cause in a multi user application should it be possible that multiple persons initiate a new record without entering the primary key value immediately....or even a single user that initiates a new record but does not complete the act entirely and leaves the PK field blank.
Other: although one can copy a back end file during use without affecting it - there may be some well-intended server functions that auto duplicate/copy/exchange files that may be the cause.
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
add a comment |
It is also possible that this 1 client uses your app differently than you expect. Users are after all the ultimate debuggers.
Any table that has a primary key that is not an autonumber - is a candidate to be the cause in a multi user application should it be possible that multiple persons initiate a new record without entering the primary key value immediately....or even a single user that initiates a new record but does not complete the act entirely and leaves the PK field blank.
Other: although one can copy a back end file during use without affecting it - there may be some well-intended server functions that auto duplicate/copy/exchange files that may be the cause.
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
It is also possible that this 1 client uses your app differently than you expect. Users are after all the ultimate debuggers.
Any table that has a primary key that is not an autonumber - is a candidate to be the cause in a multi user application should it be possible that multiple persons initiate a new record without entering the primary key value immediately....or even a single user that initiates a new record but does not complete the act entirely and leaves the PK field blank.
Other: although one can copy a back end file during use without affecting it - there may be some well-intended server functions that auto duplicate/copy/exchange files that may be the cause.
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
answered Dec 1 '18 at 19:18
Cahaba DataCahaba Data
308123
308123
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53441907%2fmicrosoft-access-database-is-in-an-inconsistent-state%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
It might be, that one or more workstations are connected via WiFi.
– Gustav
Nov 23 '18 at 7:24
Because you ask for a tip also: I suppose you already know this, but in this scenario you should really switch to a SQL Server as backend, especially since the Express version is free after all. Furthermore, I have seen anti-virus software, which monitor network traffic, do the craziest effects already.
– Unhandled Exception
Nov 23 '18 at 8:56
This has nothing to do with VBA or coding - the question is off-topic on Stack Overflow and should be asked in another venue, such as Super User.
– Cindy Meister
Nov 23 '18 at 11:29
I would also check the table structure for any memo fields. Those typically cause corruption. I found a recent article that related some corruption to certain builds of Windows 10 as well. Check to see that you don't use mde with Office 365, as that can cause a problem, and eliminate as many memo fields as possible.
– Destin Consulting
Feb 2 at 5:52