Backend Path

[NTL News Group]

How can I establish the path to the Backend (Tables) of my split database?

Regards

[MGFoster]

NTL News Group wrote:

How can I establish the path to the Backend (Tables) of my split database?

Use the Link Table Manager.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Ian]

Sorry, I tried to keep it simple, possibly too simple.

What I want to do is find the location of the backend using VBA. I want to
check some information about Windows version before running some code.
However I want to check on the backend that just has the tables and the code
runs from the front end and returns information about the front end PC.

Hope this makes sense.

[Tim Marshall]

Ian wrote:

Sorry, I tried to keep it simple, possibly too simple.

What I want to do is find the location of the backend using VBA. I want to
check some information about Windows version before running some code.
However I want to check on the backend that just has the tables and the code
runs from the front end and returns information about the front end PC.

http://www.mvps.org/access/tables/tbl0007.htm

The first function is what I use to get the back end path.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Ian]

Thanks Tim, just what I needed.
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:cv**********@coranto.ucs.mun.ca...

Ian wrote:

Sorry, I tried to keep it simple, possibly too simple.

What I want to do is find the location of the backend using VBA. I want
to check some information about Windows version before running some code.
However I want to check on the backend that just has the tables and the
code runs from the front end and returns information about the front end
PC.

http://www.mvps.org/access/tables/tbl0007.htm

The first function is what I use to get the back end path.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Douglas J. Steele]

Check the Connect property of any of the linked tables.

Something like:

Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef

Set dbCurr = CurrentDb()
For Each tdfCurr In dbCurr.TableDefs
With tdfCurr
If Len(.Connect) > 0 Then
Debug.Print "Your backend database is " & .Connect
Exit For
End If
End With
Next tdfCurr

You might also check my July, 2004 Access Answers column in Pinnacle
Publication's Smart Access. You can get it (and the accompanying sample
database) at http://www.accessmvp.com/djsteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ian" <ia********@ntlworld.com> wrote in message
news:1p**************@newsfe4-gui.ntli.net...

Sorry, I tried to keep it simple, possibly too simple.

What I want to do is find the location of the backend using VBA. I want to
check some information about Windows version before running some code.
However I want to check on the backend that just has the tables and the
code runs from the front end and returns information about the front end
PC.

Hope this makes sense.