Access 2003 populate records with LDAP information
Posted on 2005-03-21
I've got a small access 2003 database that I maintain that I use to keep track of info not contained within the LDAP database. I have inputed first and last name and a employee ID number. What I would like to do is take the personel info in the LDAP, (I.E. Phone number and Location Info) and populate my records based on the employee ID. I can successfully query the LDAP database from a command line but I have yet to figure out, or find here or google, how to populate the records based on employee ID. I would like to be able to also connect this to a form, so that when i put in the employee id # it automatically populates the form with the rest of the info. I've only got about 230 reocrds so this could be accomplished by just doing something for each record vice a script that would complete the DB all at once. 500 pts for exact step by step and pts awarded for just getting me in the right direction.