I have an issue where I have a split Access database that is accessed through both an Access front-end and a ASP.NET 2.0 web application. The database back-end resides on the web server and the Internet Guest account along with ASPNET account have full permission under the folder security. The ASP.NET 2.0 application accesses the Access database through an ODBC connection. On initial setup or after a server reboot everything works fine but the moment the web application is used (i.e. someone logs in) the Access front-end gives the user a 3073 error. The error states this query must be updatable which translates to the fact that a process of the web application has placed the db in exclusive "read-only" mode. If one trys to open the Access database directly on the web server the "This is in read-only" message appears.
My question how do I stop the web application (either IIS/ODBC or something else) from making the database read-only for all my other clients? I know this a configuration issue because I have this same setup working at a different site without this issue.
does your connection string contain "Exclusive=1"? if so then that would cause it to be exclusive and block any other connections.
you could also try putting Exclusive=0 to forcibly make it non-exclusive.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
How to install Selenium IDE and loops for quick automated testing.
Get Selenium IDE from http://seleniumhq.org
Go to that link and select download selenium in the right hand columnThat will then direct you to their download page.From that page s…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database.
Open Services Panel:
Create a new connection using New Connection Wizard:
Create a test database called eetutorial:
Create a new test tabel called ee…