A co-worker of mines set up a SQL server that I can create ODBC links to so that I don't have to import new data every week. I've built some queries for other users to run, but they can't because they don't have access/permissions to the SQL server. I was wondering if there's anyway around this or will I find a way to give everyone that uses the database access to the SQL server. The users don't need to be able to create queries or see the raw data tables. They just need to be able to use a form to run the queries/reports. Any help would be appreciated!
