I have users who currently query a SQL database using Access and an odbc
connection.  The database is being moved to a less secure server, and we are
looking for the best way for users to connect to this database so they can
do their own queries.  They like Access because they can select the tables
and don't have to remember t-sql code, and I wouldn't want to give them sql
query anaylizer anyway.  What would be the best way to do this?  Eventually
we will be creating programs for them to access their data, but that could
be a long time in coming, and there are always queries we cannot anticipate
and therefore cannot provide an application for.

Thanks.  Any ideas are appreciated.