Scriptcase hosting how to#

On this screen, you need to guide the cursor to the SQL Server for choosing it, before clicking the Next button. Hitting on the “New” button opens another window, named “Create New Data Source”. After filling this field appropriately, you must click on “New” tab. In our example, we have entered SQL Connection in the DSN name section. In the new screen, select Data Source and you will see a window appears, and then you need to insert the DSN name. After selecting this option, you should click on OK to proceed to the next step. There are two available options in the list, where you need to choose the “Link to the data source by creating a linked table” tab. In the first screen of this wizard, you will have to set the source, as well as the destination of the Access data. Clicking on the ODBC database opens a new wizard. Once you launch the Access database, you should find the External Data option from the Quick Access toolbar and choose the ODBC Database from the available list. If you don’t have an existing MS Access database, you must create a fresh one before proceeding to the next step.

The first step of the procedure is to make sure that you have an Access database. Steps of linking a Microsoft Access database to a Microsoft SQL Server database As the process in quite technical, it should only be executed by the people having sufficient knowledge about the two databases. In this tutorial, we will illustrate the process to link a Microsoft Access database to a Microsoft SQL Server database.

Scriptcase hosting how to#

We have worked out tutorials to teach people how to use WebSitePanel to manage SQL Server database and use SQL Server Management Studio to connect SQL Server and optimize SQL Server. As a proper link between the two databases keeps up with the performance of your website, in the end, it is treated as an inevitable technical part of every corporate website. As the two databases are very important for your website’s performance, you must make sure that both databases, the MS Access database and the SQL server database, are well connected to each other. With the ever-increasing advancements in the internet world, it is imperative to know the process to link a Microsoft Access database to a Microsoft SQL server database.