If a database is read-only, you can easily identify the status from the sys.databases or from the SSMS. A well-known fact is that you cannot update data in a read-only database. In this article, we will learn how to troubleshoot and fix this.
Two options
We can either use SQL Server Management Studio i.e., SSMS or T-SQL script to convert a read-only database into a read-write database. To understand these options better, let us
Create a database
Create tables within it
Add records...
Read more »
This article explains the steps for manually changing Hyperlink address in MS Access
Hyperlinks across the Internet help a great deal in reaching the designated web page quickly and easily. You can make use of Hyperlinks not just on the Internet, but also in offline documents. In MS Access you can make use of Hyperlinks in forms, reports, and tables. Hyperlinks in Access can be of great help, as they give a user the access to more information, without creating much confusion in other parts...
Read more »
In this article, we explain you the steps of using the MS Access application for scanning documents, and why you should do it.
If you have been using MS Access regularly, you would be well aware of the multitude of functionalities it offers. Although a lot of these happen to be ones the users are aware of, many of them are the ones that are not used so frequently, and we often end up forgetting completely about their existence. What we also forget is that what is not there by default in MS...
Read more »
