Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Kevin" wrote ...
If your asking ..."you can use an Access database to authorize users trying to access your spreadsheet", yes you can. You can query an Access DB using DAO methods. Using ADO and the OLEDB 4.0 provider for JET in Excel VBA code, one can execute DDL sql relating to security: groups, users, passwords. See: http://msdn.microsoft.com/library/de...l/acadvsql.asp Jamie. -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
How to access ACCESS from Excel! | Excel Programming |