Sunday, February 12, 2012

Accessing Remotely located SQL Server via Access

Hi,

I need the code to create a connection between the Sql server using ACCESS form.

Can I do this. If yes . can you help mw with it.

Currently I am accessing the server with remote desktop connection

Regards,

Jay

There is a fairly useful resource for this process in Access help under "Import or link SQL database tables or data from other ODBC data sources". Just search for that string in Access help, and there will be a whole bunch of information on this topic. Hopefully, this will provide you with all you need to connect to SQL server.

Hope this helps!

John (MSFT)

|||

There is a fairly useful resource for this process in Access help under "Import or link SQL database tables or data from other ODBC data sources". Just search for that string in Access help, and there will be a whole bunch of information on this topic. Hopefully, this will provide you with all you need to connect to SQL server.

Hope this helps!

John (MSFT)

|||

Open the destination database (access database which you want linked to SQL Server)
On the External Data tab, in the Import group, click More.
Click ODBC Database.
Click Link to the data source by creating a linked table, and then click OK.

Click New to create a new data source name (DSN).
The Create New Data Source Wizard starts.

In the wizard, select SQL Server in the list of drivers, and then click Next.

Click Next, review the summary information, and then click Finish to complete the Create New Data Source Wizard.
The Create a New Data Source to SQL Server Wizard starts.

In the wizard, type a description of the data source in the Description box. This step is optional.
Under Which SQL Server do you want to connect to, in the Server box, type or select the name of the SQL Server computer to which you want to connect, and then click Next to continue.
On this page of the wizard, you might need to get information from the SQL Server database administrator, such as whether to use Windows NT authentication or SQL Server authentication. Click Next to continue.
On the next page of the wizard, you might need to get more information from the SQL Server database administrator. If you want to connect to a specific database, ensure that the Change the default database to check box is selected, select the SQL Server database that you want to work with, and then click Next.
Click Finish. Review the summary information, and then click Test Data Source.
Review the test results, and then click OK to close the SQL Server ODBC Data Source Test dialog box.
If the test was successful, click OK again to complete the wizard, or click Cancel to return to the wizard and make changes to your settings.


Click OK.
Access displays the Link Tables dialog box.

Under Tables, click each table or view that you want to link to, and then click OK.

Regards,

Designing-Systems.com

No comments:

Post a Comment