Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 12th, 2005, 07:22 PM
SoC SoC is offline
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default Getting data from linked tables

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

 
Old October 13th, 2005, 03:03 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

Cheers,

Chris

 
Old October 13th, 2005, 08:18 PM
SoC SoC is offline
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Effect of Linked tables on Original Data alexlist Access 2 January 3rd, 2007 04:03 PM
Linked Tables edojan Access 1 July 20th, 2006 10:49 AM
Linked Tables ru1 Access 1 September 21st, 2005 07:24 AM
Linked Tables ricmar Access VBA 6 July 28th, 2004 05:08 PM
Access Linked Tables StephenDID Access ASP 6 October 6th, 2003 10:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.