Hi,

From what I've read, it seems that it is impossible to get data from a linked table and display it on a web page. Apparently you always need to query the original data source.

Is this really true? It would make my life a lot easier if I could simply query a linked table. Is there some little trick you can use?

Thanks

Can you describe exactly what you are trying to do along with your db structure?

Cheers,

Chris

Okay,

Basically what I am trying to do is not the way it should be done, but for the moment I am just exploring possibilities.

We have started to experiment with Sharepoint Services (SPS). SPS can hook into Active Directory (AD) and pull out a list of users, along with contact details etc. The problem is it presents it in a silly format, with no real search capabilities. SPS also has the ability to create a linked Access table from the user/contacts list. What I wanted to do was query this table, but so far it doesn't work, and I don't really expect it to, because it links straight into AD.

I guess I need to do it properly, and start mucking around with LDAP to query AD directly, but this is a pain cos I don't have any experience with it.

There are a few tutes out there, but any further help is most welcome

Thanks