Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MODIFY CONNECTION Command

Visual Studio .NET 2003

Displays the Connection Designer, making it possible for you to interactively modify an existing named connection stored in the current database.

MODIFY CONNECTION [ConnectionName | ?]

Parameters

ConnectionName
Specifies the name of the connection to modify.
?
Displays the Open dialog box from which you can choose an existing named connection to modify.

Remarks

If you omit the optional arguments, the Open dialog box is displayed, making it possible for you to specify an existing named connection to modify. The Connection Designer is displayed after you choose a named connection to modify.

Example

The following example assumes an ODBC data source called MyFoxSQLNT is available, and the user ID for the data source is "sa." The testdata database is opened, and a connection named Myconn is created. MODIFY CONNECTION is used to displays the Connection Designer so you can modify the connection.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'data\testdata')

CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "sa"
MODIFY CONNECTION Myconn && Displays named connections in the database

See Also

CREATE CONNECTION | DELETE CONNECTION | OPEN DATABASE | RENAME CONNECTION

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.