We currently have a few users who have been using Access very succesfully to throw around large amounts of data.
We've now got to the point where the data is just too large to be held in Access, as well as wanting to hold it in a single place where multiple users can access it.
We have therefore moved the data over to SQL Server.
I want to provide a general tool that they can use to view the data on the server and do some simple things like run queries and filters and export the data for offline manipulation.
I don't want the support headaches that might come with rolling out SQL Management Studio, and neither do I want to have to create an Access database with links for each current database or ones that are created in the future.
Can anyone recommend a simple tool that will connect to a server, list all the databases and allow a user to drill into a table and look at the data.