Hi,
We have an application that does the following:-

- As a night job, all the tables in a database are zapped and updated with the latest data
- The users perform diffeernt queries on the database during the day. This is a read only application. It just servers as a window to the database.

Now we are considering providing access to a few contractors to this application. The current plan is use to use a Terminal server. The exe and the database would be on the terminal server and the contractors could use the application via the terminal server. To start with we might have 15 contractors, but eventually this would increase.

1.
Is Terminal server the right answer to the problem? If so what should be our other considerations?

2.
Would it be a better solution, to have the exe and the database on the contractors' server? In this case after the database has been updated on our end at night, how do we send the data over to the contractor's server? can we FTP this?

Any help would begreatly appreciated.

Thanks in advance.

Ria