Client-Server Setup Question

Hello All!

I have a question for you database nuts! I have created an application that is will search a database and produce the query results in a form. There are several users that will be using this application, and my question is, do I just install the program on the server they want to use, or do I create a custom setup program that will allow the installer to select the server to put the database on and save that path for the ADO connection strings?

This is the first time I've ever actually created an application like this, but I have several other ideas for similar projects, so any help will be more than greatly appreciated!

Thanks in advance,

Jim Piller
[email protected]

Allowing the user to choose the server on which to store the databases might prove to be a little more expensive. I'd suggest you put the db on a single server, don't let the user choose.

I was thinking the same thing, but I just wanted to make sure that was going to be the correct way to go...thanks for the input.

Jim