how to: use active directory users in access database????

[sgscit]

Hi Folks,

I'm creating a database for asset tracking and want to import or use live active directory data in the database.

an example.

computer A is assigned to AD user JoeBlow
Software package A is also assigned to JoeBlow.

any ideas?

Cheers,

Pete

 

[Blorf]

I do not know what live active directory data means.

Your example sounds like you want to know who something is assigned to, and the location it is stored.

Can I ask if you want to use it for depreciation or just to know what you got?


Ascii dumb question, get a dumb Ansi

 

[sgscit]

I'm creating a database so that the hardware we purchase can have users assigned to it.

I have an active directory full of users and want to be able to assign users to PC's or other hardware.

If I make a change in AD - ie a woman gets married and her maiden name changes, I want it to auto update from AD (ie live data).

another example is a new user is created in AD and thier details are automatically in the database to be assigned to a peice of equipment.

The db is essentially for inventory and assignment purposes.

I was asked today what equipment we have (the insurance company wants to know.) My answer was, "I can guestimate?"

Cheers,

Pete

 

[cmmrfrds]

If I make a change in AD - ie a woman gets married and her maiden name changes, I want it to auto update from AD (ie live data)."

Are you expecting AD to update your Access database?
Or
Do you want to read the AD and update your database through a process in Access?

Do you have sql server available?

 

[sgscit]

Yes I do have sql server and will be putting the db into it(importing) once I have finished setting it up.

As for updating the data, even if I could run a script to go and get the fresh details from AD would be handy.

Cheers,

Pete

 

[cmmrfrds]

You should be able to read the AD using the Microsoft OLEDB Provider for directory services. You could connect with oledb and create an ADO recordset from the AD. Another way, which I would be inclined to use, is to use the oledb provider to make a linked server on the sql server side. This way you could treat the AD like any other sql server table. This would be done with the same oledb provider.