Good morning,
I have an Access 2003 database containing details of users from a SQL database.
Unfortunately the SQL databse, of which I only have read access, only contains users email displaynames from AD not their actual SMTP addresses, which I need to update some data elsewhere following reporting from Access.
I have tried to carry out an Import Table and Linked Table from Access but this seems to time out. I think that our GAL has ~ 200k entries, so this would be understandable.
I have therefore decided that I should look at obtaining the information by looking it up using VBA and an LDAP query. I have found many examples on the internet but am having issues in getting any of them to work.
All I need to do is look up ID in AD and retrieve the SMTP email address.
Can anyone assist please?
Thanks.
I have an Access 2003 database containing details of users from a SQL database.
Unfortunately the SQL databse, of which I only have read access, only contains users email displaynames from AD not their actual SMTP addresses, which I need to update some data elsewhere following reporting from Access.
I have tried to carry out an Import Table and Linked Table from Access but this seems to time out. I think that our GAL has ~ 200k entries, so this would be understandable.
I have therefore decided that I should look at obtaining the information by looking it up using VBA and an LDAP query. I have found many examples on the internet but am having issues in getting any of them to work.
All I need to do is look up ID in AD and retrieve the SMTP email address.
Can anyone assist please?
Thanks.
