>>What is the remote server? SQL Server, Oracle, ...? Yes you do need more >than just select or read privs.
>
>It's an Oracle server. Unfortunately I don't know the privelages when using Foxpro SQL passthrough, but I'm under the impression that it is just select or read privs. However we might be changing to SQL server with different privelages. Any advice on getting started at this if I do have the right privelages?

You have a privilege issue regardles of the database. You have to have Insert, Update, Delete privs on either server to do this. IF you can not add, change or delete data, then you need to talk to your Oracle DBA about getting these privs.