How To Build Web Database SharePoint-Access

Are you looking to build a web database in SharePoint using Access? Follow these steps to get started.

To build a web database in SharePoint using Access, you need to follow a specific process. First, you must create a SharePoint Server web application, which consists of an Internet Information Services (IIS) web site. This web application is represented by a different IIS web site with a unique or shared application pool. You can assign each web application a unique domain name to prevent cross-site scripting attacks.

When creating a new web application, you also create a new content database and define the authentication method used to connect to the database. Once the web application is created, you can add an existing content database to it. This can be done through the Central Administration by selecting the desired web application and adding the content database.

It is important to ensure that the SharePoint Farm Version in SharePoint Central Admin and in the content database is the same. If there is a version mismatch, you can manually update the version information in the content database.

Follow these steps to successfully build a web database in SharePoint using Access and streamline your data management process.

Creating a SharePoint Server Web Application

To begin, you need to create a SharePoint Server web application, which consists of an IIS web site and a unique domain name. This web application serves as the foundation for your web database in SharePoint. It provides the necessary infrastructure to host your database and connect it to the SharePoint environment.

The first step in creating a SharePoint Server web application is setting up an Internet Information Services (IIS) web site. This involves configuring the IIS settings, such as specifying the port number and IP address for the site. Additionally, you can assign a unique domain name to the web application, which adds an extra layer of security by preventing cross-site scripting attacks.

Once the IIS web site is set up, you can define the authentication method used to connect to the database. SharePoint offers various authentication options, such as Windows authentication or forms-based authentication, depending on your organization’s requirements and security policies.

By following these steps, you can create a SharePoint Server web application that serves as the backbone for your web database. This application provides a secure and robust environment for hosting your database and ensures seamless integration with the SharePoint platform.

Adding an Existing Content Database

After creating the web application, you can proceed to add an existing content database by accessing the Central Administration interface. This interface allows you to manage various aspects of your SharePoint environment, including adding content databases to your web applications.

To add a content database, follow these steps:

  1. Open the SharePoint Central Administration interface.
  2. Navigate to the “Application Management” section and click on “Manage content databases”.
  3. On the “Manage Content Databases” page, select the desired web application from the drop-down menu.
  4. Click on the “Add a content database” button.
  5. In the “Add Content Database” dialog, enter the necessary information, such as the database name and database server.
  6. Click “OK” to add the content database to your web application.

It is important to note that while adding a content database, you should ensure that the SharePoint Farm Version matches the version in the content database. This is crucial to avoid any version mismatch issues that may cause compatibility problems or data corruption.

If you encounter a version mismatch, you can manually update the version information in the content database. This can be done through SQL Server Management Studio by executing specific queries or using PowerShell scripts provided by Microsoft. Always make sure to back up your content database before performing any updates or modifications.

Summary

Adding an existing content database to your SharePoint web application is a straightforward process that can be done through the Central Administration interface. By following the steps outlined above, you can seamlessly integrate the content database and ensure compatibility with the SharePoint Farm Version. Remember to always double-check the versions to prevent any potential issues that may arise from version mismatches.

Step Instructions
1 Open the SharePoint Central Administration interface.
2 Navigate to “Manage content databases” under the “Application Management” section.
3 Select the desired web application from the drop-down menu.
4 Click on “Add a content database”.
5 Enter the necessary information in the “Add Content Database” dialog.
6 Click “OK” to add the content database.

Ensuring Compatibility and Updating Version Information

It is crucial to verify the compatibility between SharePoint Farm Version and the content database, and in case of a mismatch, update the version information manually.

After adding an existing content database to your SharePoint Server web application, it is essential to ensure that the SharePoint Farm Version matches the version in the content database. Keeping both versions aligned is important to ensure the smooth functioning of your web database.

If there is a version mismatch, you can manually update the version information in the content database. This can be done through the Central Administration interface. By selecting the desired web application and navigating to the content database section, you can modify the version information to match the SharePoint Farm Version.

Updating the version information will help maintain compatibility between the SharePoint Farm Version and the content database, ensuring that all features and functionality work seamlessly. It is recommended to regularly check for version mismatches and update the information as needed.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.