| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access security and excel external data
tmountjr wrote:
Ideally, I'd like to supply Excel with a username and password, then set up that user on the .mdw side so that it has access rights only to the necessary queries. Can I do this? CreateWorkspace is DAO. ADO is more popular in these groups. For sample ADO connection strings using the OLE DB provider for Jet, see: http://www.able-consulting.com/MDAC/...orMicrosoftJet AFAIK as well as granting permissions to the query you have to grant permissions to the underlying tables, queries, etc the query uses. Jamie. -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2010 (64 bit) External Data connection with Access | Excel Discussion (Misc queries) | |||
| Excel Security when using external data | Excel Discussion (Misc queries) | |||
| Excel Table Drawing Data from Access - security?? | Excel Programming | |||
| Retrieving External Data from Access into Excel | Excel Programming | |||
| Export Excel data to Access Security problem | Excel Programming | |||
![onedaywhen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
