mbentley
Registered User.
- Local time
- Yesterday, 21:19
- Joined
- Feb 1, 2002
- Messages
- 138
I'm helping someone implement user-level security on their Access 97 database, and we've run across an interesting snag.
There are external Excel and Word documents that query the database for information through MS Query. I have set up the database to be access through a shortcut that links to the secured WIF rather than connecting Access directly to the secured WIF.
As expected, when the MS Query is run a permissions error is returned because the user is not joined to the secure WIF.
I have never set up a database this way, so am not overly familiar with the syntax. Is there a way to add an arguement to the SQL statement that links to the secured WIF on the fly?
There are external Excel and Word documents that query the database for information through MS Query. I have set up the database to be access through a shortcut that links to the secured WIF rather than connecting Access directly to the secured WIF.
As expected, when the MS Query is run a permissions error is returned because the user is not joined to the secure WIF.
I have never set up a database this way, so am not overly familiar with the syntax. Is there a way to add an arguement to the SQL statement that links to the secured WIF on the fly?
