After playing with the code from the the link See http://www.dbazine.com/ofinterest/oi-articles/celko32 from Karl Fiderl this is what i ended up doing - not a perfect solution but it does...

Hi Carl I still have to lookat at the URL as there is serious logic in the examples

Scott and CJohnson - thankyou for the ideas and code, unfortunately it doesnt...

Hi Kenneth et al

I have to update allocation with 1's as u c below. One credit can match many debits or just one debit. There can be more than one...

Problem solved - I have a txt file which is a list of SQL instances that is loaded into a combo box. The offline backup server is the first in...

They are members of the domain - we only have one domain and yes they are members of the security group

VBA connection string as follows

'Use the SQL Server OLE DB...

The error I am getting is related to the field type

There are a number of fields in AD which are "multivalue" fields ie array fields

Description, country, SMTP address are examples...

Hi Steve

Thanks for the reply

Our Active Directory name is setup as XXXNet.Local

SQLAccount is a domain user which is a member of Administrators and domain users, but not domain admin etc

So...

I have established a few things

1. THE MSDN example is incorrect

'file:\\.\backofficestorage\localhost\public folders' does not work nor the local domain name but the exchange domain ie the email address domain does....

I get the same message however I am still able to get AD info into a view or table only if I create the linked server with an NT logon...