|
 |
access thread: Access back end path
Message #1 by "Clive Astley" <clive.astley@p...> on Sun, 29 Jul 2001 17:06:42
|
|
How can I find the path of an Access database back end please?
Message #2 by "Bob Bedell" <bdbedell@m...> on Sun, 29 Jul 2001 21:36:21 -0400
|
|
You might try opening your front end and doing Tools>Database
Utilities>Linked Table Manager. Paths to your linked tables should be listed
there. Another way, if your using ADO or DAO would just be to search your
code modules for the file extension of whatever type of back end it is your
linked to. That will find your connection string which contains the path.
>From: "Clive Astley" <clive.astley@p...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Access back end path
>Date: Sun, 29 Jul 2001 17:06:42
>
>How can I find the path of an Access database back end please?
>
Message #3 by "Richard Lobel" <richard@a...> on Sun, 29 Jul 2001 21:28:03 -0700
|
|
In code or in the Access interface?
Richard Lobel
Message #4 by "Peter Kaufman" <kaufman@l...> on Mon, 30 Jul 2001 17:08:25 +0700
|
|
Function fnFindBE() As String
Dim sConnect As String
Dim iStartofString As Integer
Dim iEndofString As Integer
Dim sFCName As String
sConnect = CurrentProject.Connection.ConnectionString
iStartofString = InStr(1, sConnect, "Data Source=") + 12
iEndofString = InStr(iStartofString, sConnect, ";")
sFCName = Mid$(sConnect, iStartofString, iEndofString - iStartofString)
fnFindBE = fnFindLastSlash(sFCName)
On Error GoTo procError
ProcExit:
Exit Function
procError:
Select Case Err.Number
Case Else
MsgBox "Error #" & Err.Number & ": " & Err.Description, _
vbOKOnly + vbCritical, "fnFindBE"
End Select
End Function
-----Original Message-----
From: Clive Astley [mailto:clive.astley@p...]
Sent: July 29, 2001 5:07 PM
To: Access
Subject: [access] Access back end path
How can I find the path of an Access database back end please?
---
Message #5 by "Pardee, Roy E" <roy.e.pardee@l...> on Mon, 30 Jul 2001 08:58:33 -0700
|
|
I'm still a DAO-head, but I use:
strBEPath = Mid$(CurrentDb.TableDefs("Dummy").Connect, 11)
Where "Dummy" is the name of a table that you know is linked to the
back-end.
HTH,
-Roy
-----Original Message-----
From: Clive Astley [mailto:clive.astley@p...]
Sent: Sunday, July 29, 2001 10:06 AM
To: Access
Subject: [access] Access back end path
How can I find the path of an Access database back end please?
Message #6 by "Clive Astley" <clive.astley@p...> on Mon, 30 Jul 2001 21:22:02
|
|
> How can I find the path of an Access database back end please?
Thanks to all who replied. Roy's suggestion seems the simplest and works a
treat for what I want to do.
Best wishes,
Clive
Message #7 by "Rogers, Robert" <rrogers@b...> on Mon, 30 Jul 2001 16:53:45 -0400
|
|
Good Afternoon,
Steps:
1. Select Tools on the Main Menu
2. Add-ins
3. Linked Table Manager
v/r
Robert L. Rogers
Rexel Branch Electric
Application Developer
xxx-xxx-xxxx
-----Original Message-----
From: Clive Astley [mailto:clive.astley@p...]
Sent: Monday, July 30, 2001 5:22 PM
To: Access
Subject: [access] Re: Access back end path
> How can I find the path of an Access database back end please?
Thanks to all who replied. Roy's suggestion seems the simplest and works a
treat for what I want to do.
Best wishes,
Clive
|
|
|
View Cart
