• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

Access 2003 populate records with LDAP information

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.
1 Solution

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now