Adrianna
Registered User.
- Local time
- Today, 19:42
- Joined
- Oct 16, 2000
- Messages
- 254
I'm using Access to run VBA scripts in order to generate reports for my coworkers. I've been doing this all from my desk, but would like to be able to create a switchboard to allow them to create their own form driven queries and push button reports.
The issue is that I'm actually using an MS SQL 2000 (being converted to SQL 2005) database, so I require an ODBC in order to run my scripts through access. In order for coworkers to utilize the switchboard, they also need the ODBC.....which leads me to lack of security for my data. Although I can create logins and restrictions in Access, the mere fact that the have the ODBC gives them direct access to my repository.
Does anyone know of a way to get around this?
The issue is that I'm actually using an MS SQL 2000 (being converted to SQL 2005) database, so I require an ODBC in order to run my scripts through access. In order for coworkers to utilize the switchboard, they also need the ODBC.....which leads me to lack of security for my data. Although I can create logins and restrictions in Access, the mere fact that the have the ODBC gives them direct access to my repository.
Does anyone know of a way to get around this?