>Thanks for the information.
>
>Questions. Where do I put that OpenRowSet function? Do I need to create a store procedure or something in SQL?
>Also, our FP tables are stored in the file server(Novell) and SQL is in the database server(Win2000). Do they have to be in the same server?
>

No. You can use UNC pathing to access data when the tables aren't on the same machine. Just replace "D:\..." with "\\MachineName\ShareName".

>I was told it's more secure to have the remote access than getting into the FP tables(they are accounting data) directly. Therefore I was looking for the way.
>Is it true?
>

Well I'm not sure about this. You are accessing the data via Cold Fusion. You could implement some security there. If you go the SQL Server route, you could implement some security there. Depending on the Novell version, you could add some security there.

IAC, if you really are worriesd about messing up the data, you could set up a DTS job to copy the VFP tables into SQL Server on a regular basis (daily, hourly). The DTS job would essentially make a clone of the VFP database and you could access it via Cold Fusion without anyone ever touching the base data. Of course this doesn't give you real time information but it may be enough for what you want.