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

Example

The following example assumes an ODBC data source called MyFoxSQLNT is available. 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.

	Copy Code
CLOSE DATABASES OPEN DATABASE (HOME(2) + 'data\testdata') CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "<userid>" PASSWORD "<password>" MODIFY CONNECTION Myconn && Displays named connections in the database

See Also