Thread: Access
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Access

"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.

--