Can you UPDATE a remote MS-SQL table?

[CaelC]

I have a remote MS-SQL DB I am trying to "hook up to". I have an SQL person helping me as I am clueless here. We got a DSN assigned and I have scripted a series of imports from ODBC data source to bring data down from the web server via TCP-IP (I'm still having some trouble bringing in data from his stored procedures and/or join fields however).

Apparently in Access, it is also easy to have the local DB act as an interface for the remote data source, even allowing UPDATING of data on the remote server. For example...I change a field value locally and it automatically changes on the server to match.

1. Is this possible in FileMaker?

2. Is it rocket science or can a competent FileMaker person do it without knowledge of SQL???

Please help!

Thanks, Cael.

[cjaeger]

>I change a field value locally and it automatically changes on the server to match

Don't do it. this really places a heavy load on the network and on the database. alsways work with submit buttons and possibly scripts to transfer several records/values at once.

I use a closing script which transfers records that have changed since opening the file using global open/datetime fileds and local modification date/time.

As for the rocket science: since you already have set up your dsn. the hard part is already done.

[CaelC]

Thanks.

Do you just run a script with an Execute SQL step in there?

What does the SQL step have to do?

Does it replace all data in the remote records, or just changes to certain fields?

Thanks, the help is appreciated!

Cael.