>HI,
>I have a seperate DBC only store my local view. Now, I would like to upsize my database. How could I convert my local view that store in view only dbc to remote view?
>
>Thank you

1. You will need an ODBC data source:
Choose the Administrative Tools icon from the Windows Control Panel.
Choose the Data Sources shortcut.
In the ODBC Data Source Administrator dialog box, click Add, then select the driver you want from the Installed ODBC Drivers list and choose OK.
In the Setup dialog box, set option values as necessary and choose OK.

2. In your VFP database, you will need to create a new connection:
In the Project Manager, select a database.
Select Connections and choose New.
In the Connection Designer, enter the options that correspond to your server requirements.
From the File menu, choose Save.
In the Save dialog box, enter a name for the connection in the Connection Name box.
Choose OK. You can also create a connection by choosing New from the File menu and selecting the Connection option.

3. Now you can create your remote view...it will be just like how you create a local view excpept you have "remote connect [connection name]" in it... for example:

CREATE SQL VIEW "MyRemoteView" ;
REMOTE CONNECT "CONNECT1" ;
AS SELECT mytable.myfield1, mytable.myfield2 from mytable

....connect1 is the name you created in step 2 above....