[AccessD] Linked Tables

Good point Andy. It almost worked for me but I am working with a DB that is 
linked in Windows SharePoint Services so the link is to a table on a server in 
the USA and the link is created via the site address.

The data on the WSS machine is stored in MSDE 2000 I think. I am assuming its 
in MSDE as WSS appears to store all data in MSDE tables.

I am trying to find out the database details for the link. 

Its all a bit new to me (<:

The code below returns the full URL to the Sharepoint server but still not 
hitting the actual DB. Not sure if its even possible but interesting none the 
less.

Martin


Quoting Andy Lacey <andy at minstersystems.co.uk>:

> mmm, not quite Stuart. As we found out on BEU the ;DATABASE= normally
> comes in the 11th position of the string but not always. For exasmple
> a
> password restricted MDB has extra in the connection string so
> DATABASE=
> appears later in the string. The safer way is to search for the
> position
> of DATABASE=
> 
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> > Stuart McLachlan
> > Sent: 26 April 2003 14:36
> > To: Mwp.Reid at queens-belfast.ac.uk; accessd at databaseadvisors.com
> > Subject: Re: [AccessD] Linked Tables
> > 
> > 
> > On 26 Apr 2003 at 11:44, Mwp.Reid at queens-belfast.ac.uk wrote:
> > 
> > > Is it possible via code to determine the source of a linked table?
> > > 
> > > 
> > 
> > Look for the Connect string:
> > 
> > Dim tdfloop As TableDef
> > With CurrentDb
> >         For Each tdfloop In .TableDefs
> >             If Left$(tdfloop.Connect, 10) = ";DATABASE=" Then
> >                  Debug.Print Mid$(tdfloop.Connect, 11)
> >             End If
> >         Next tdfloop
> > End With
> > 
> > 
> > -- 
> > Lexacorp Ltd
> > http://www.lexacorp.com.pg
> > Information Technology Consultancy, Software Development,System 
> > Support.
> > 
> > 
> > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>