Access meldet, dass sich Datenbanken in einem "inkonsistenten Zustand"
befinden
https://support.office.com/de-de/article/access-meldet-dass-sich-datenbanken-in-einem-inkonsistenten-zustand-befinden-7ec975da-f7a9-4414-a306-d3a7c422dc1d

Hallo Access Team,

hier ein paar Informationen in der Hoffnung, dass diese helfen, da ich im Berufsalltag gerade viel Arbeit mit diesem Thema habe:

Programm DB und Daten DB im Shard Netzlaufwerk (ich weiß, ist nicht ideal).
Früher: Nur Windows 7 und Office 2010
Aktuell: Windows 7 + Windows 10 + Office 2010 User

Ich habe den Verdacht, dass User, die über ein Citrix Windows 10 (schlecht Netzverbindung) auf Programm und Daten zugreifen, das Problem verursachen könnten.

Ich habe den Verdacht, dass bei starker Netzauslastung in der Firma das Problem verursacht wird.

Ich habe den Verdacht, dass wenn zu viele User gleichzeitig auf die Datenbank zugreifen (ca. 10) das Problem verursachen.

Der File Server steht an meinem Standort. Ich habe den Verdacht, dass gerade User von anderen Standort (z.B. via Citrix Windows) das Problem verursachen.

Anscheinend wird immer nur die Programm-DB beschädigt. Das Backend, die Daten-DB funktioniert nach Austausch der Programm-DB problemlos weiter.

Ich hoffe, ich konnte etwas helfen und Sie finden bald eine Lösung.

Ärgerlich ist es, dass man der Microsoft Support Seite nicht direkt Informationen hinterlassen kann.

Client on Office Insider build 16.0.12325.20172 where MS Access is linked to SQL backend.

ALL non-action Pass-Through queries fail with a message of "Invalid cursor state", even the most simple like "SELECT x FROM tblY". Executing a stored procedure via pass-through query also fails with same error. Action pass-through queries do work. Standard MDB queries do work.

I didn't have access to this computer to do significant testing to know what else did/did not work. Client was working fine as of Friday, but errors on Monday, after Office updated to that version on Sunday. IT has now uninstalled their Office and installed a different version and the pass-through queries work again.

Anyone else on build 16.0.12325.20172, linked to SQL tables, have the same problem?

Introduction

Microsoft Access is an application for database which a lot of companies, schools, colleges, and universities are using it in order to manage the information of their employees or students. Our project tending to make Microsoft Access easier to be used by its users by improving the security of the databases and the ease of entering the information into these databases. Nowadays the barcode scanners are popular in almost everywhere, and the QR scanners. Our project is to link a barcode/QR scanner to Microsoft Access in order to make it easier to enter the information to the databases and it will be faster. A part of our project is the security for these databases because the information in these databases must be used only by the authorized people not for everyone.

Microsoft Access has a basic security option which is encrypting the database by a password which is king of easy to hack it or break it. In order to make the hacking or braking through the password harder, we thought about linking a security device to Microsoft Access in order to keep the databases safer. In the current version of Microsoft Access, we need an intermediate software in order to link the software of the security device in order to work properly. The problem in this intermediate software is they are very expensive because they considered to be luxuries which people use it to make their work easier. We thought about providing Microsoft access with the direct ability to accept any security device which it needs to be linked to it without any intermediate software in order to make the luxuries things public to let the people use it as if it is basic things with a little higher cost for Microsoft Access. 


Microsoft Office has only one way to enter the data into the tables which is by typing the data into the form which is related the targeted table. Sometimes this way is hard for some people who are using Microsoft Access. Many people on Microsoft website were asking in their comments about a faster way to enter the information into the table because they are having hard time entering the information to the tables by typing because there are a lot of information they have to enter them to their databases, so the people were asking if the barcode/QR scanner could be able to be linked to Microsoft Access or not, and what are the requirements to link a scanner to Microsoft Access. The solution is very easy, but it is very expensive. The solution is an intermediate software has toby installed to link the software of the scanner to Microsoft Access in order to work properly then the user can choose which form will use to enter the data into it. Our project is tending to let the users to link the barcode/QR scanners without any intermediate software with a little bit higher cost for Microsoft Access.   

Microsoft Access has no dark mode option although the new updates for the other database applications provide dark mode nowadays. People like the dark mode in the applications because it relaxes their eyes when they stay a long time in front their computers. In our project we tending to provide Microsoft Access with the dark mode option in order to let the users feel comfortable while using the application, and to be able to read the information clearer than the light mode.

The good database application is the application which suits all the computer devices. Although Microsoft Access is a very good database application, apple users cannot use Microsoft Access on apple computers. It has been a big problem for many people specially students that they cannot use Microsoft Access on their apple computers because it is not supported in apple computers. Our project is to let apple computers to support Microsoft Access in order to be reachable for all the users.

Requirements

Microsoft Access is a good database application, so it deserves to be improved in order to be easier and more secure. In order to make Microsoft Access easier to be used by the users, we need to add the ability to link the barcode/QR scanner into it directly without an intermediate software. The requirements are as follows; we are going to post an update for Microsoft Access which will contain a built-in software to link the scanner device directly to Microsoft Access. The built in software will let the user to choose between the forms which related to the deferent tables in the database in order to let the user scan the barcode or the QR code in order to enter the data into the targeted form. The software will also let the user to choose the way by which he/she can enter the data with; the choices will be between entering the data by typing or entering the data by the scanner. The software will ask the user if he/she wants to keep a default form when starting the data entry proses, or the user must choose every time between the forms in order to get every data in its suitable table.


Microsoft Access has a basic security system which is encrypting the database to be unlocked by a password. Our project is to add the ability to Microsoft Access to link security devices without an intermediate software. We need to post an update to Microsoft Access which has a built-in software to let Microsoft Access to link with the security devices directly. There are many security devises such as the fingerprint reader, the face identification device, the tooth identification device, the eye print reader, and a proxy card reader. The built-in software will ask the user if he/she wants to encrypt the database by a password as the basic way or to use the security device to encrypt the database by ether ways according to the security device by putting your fingerprint to encrypt the database and also use your fingerprint to unlock the database to open, or by any way which the security device provides you to encrypt and to unlock the database. The built-in software will ask to add one or two as maximum persons to be the administrators to save their identities because it cannot be open for everyone in order to keep the databases safe abs accessible by the authorized people only.

Most of the updates for database applications provide the dark mode to their users. In order to provide Microsoft Access with the dark mode option, we need to post an update for Microsoft Access which provide the users with the dark mood option. Microsoft Access will ask the user if he/she wants the appearance to be on the dark mode or on the light mode when the user start setting up his/her account on Microsoft Access then the user can later change the appearance from the settings of the application when the user wants.

Many people epically the college students facing problems when they try to use Microsoft Access on their apple computers because Apple computers do not support Microsoft Access. We will design a software on Appstore studio which will let Apple computers to install Microsoft Access without facing any problems like the Android Emulators and IOS Emulators on the computers which they allow the users to install the Android applications and IOS applications on the computer, so the software which we will design will be on the same way of these applications, but it will be designed to install Microsoft Access on Apple computers easley.

Why can you not make ACCESS available on Mac? This is the 21st C not the Dark Ages. I have moved from Windows laptop to a 64-bit Mac and have an annual subscription to Office 365. Why is Access NOT available to me as it was before? I cannot be the only person in the world with this problem. I am not a computer expert, just a fairly competent user. If you can develop Word, Excel, etc etc for Mac why not Access? I really don't understand the problem. My databases are now useless to me, as are those of millions of other users worldwide. Help!