I have an application on a network that is going to be distributed to a handful of clients. There are certain controls within my application (such as a combo box) that have certain values, which must be filled in from a table within a database on the central NT server. I have an ODBC connection setup on that NT to the database.

I can map a drive to that database internally, but what is the best method here? Let's just keep it simple.

I have a table that has two fields (NameID, Name) and I want to use these to populate a cmbBox, where NameID is the Index value for the Name that is listed in the cmbBox for the user to see and select from.

What should I do?

I hope this is simple enough to be provided with some sample code that is basic. I want all users to have read access to this database table at any time.