Cracked it!
Not sure if anyone wants this, but i have fianally sorted out how to get the active directory data, ie, username, Lname,Fname, fullname and email from AD and ito Liberum. This is for sql only, but im sure you can do similar things with access. First off, you need to create an ADSI server link in your SQL server instance, (im running sql 2000 btw). to do this, simply run the following in query analyzer:
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'
Now you can run ADSI queries. You will need a query similar to :
SELECT * FROM OpenQuery (ADSI, 'SELECT Mail,CN,SN,GivenName,sAMAccountname FROM ''LDAP://DC=xxx,DC=xxx' where objectClass = ''user'' AND objectCategory=''person'' AND SN =''*'' AND Mail =''*'' ')
Make sure you remove the carriage returns or it wont work. also, where i have the xxx's is a tricky part, depending on how you have your domain set up. say if mine was "Google.com" then it would be:
'LDAP://DC=google,DC=com'
Make sense? also, those quotations are two[ ' ] not one ["]
Next step is to have sql agent drop and create a view, say: vADUsr, on whatever schedule you would like, using the above query. Then, you can get DTS to rip that data into the user table on an hourly basis, or whatever time you would like. If you were really keen, you could get rid of the user table altogether and just link using the "sAMAccountname", possibly, but i havent delved in that far as yet.
Enjoy!!