Results 1 to 4 of 4
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Currentdb.name okay to get front-end. How about the back-end name

    Currentdb.name okay to get name of front-end. How does one get the name of the back-end?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I use this function to get the path name from the connection string,
    I use a linked table (pick yours, mine is tAlpha) , an external linked table to determine the path:

    Code:
    Public Function getBeDbFromLink()
    Dim vLink
        vLink = CurrentDb.TableDefs("tAlpha").Connect
        If vLink = "" Then
           getBeDbFromLink = CurrentDb.Name
        Else
           getBeDbFromLink = Mid(vLink, 11)
        End If
    End Function

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    if all your tables are linked to the same BE you could use

    dlookup("Database","MsysObjects","[Type]=6")

  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Thanks for the suggestions guys. With the app of interest, all the tables are in a single backend so the dlookup will work great.
    Bill

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pass changes from front end to back end
    By BigJohn89 in forum Database Design
    Replies: 2
    Last Post: 06-21-2018, 04:36 AM
  2. Front End vs. Back End
    By athyeh in forum Access
    Replies: 2
    Last Post: 07-08-2013, 01:28 PM
  3. Replies: 5
    Last Post: 05-27-2013, 09:34 AM
  4. Front end link to back end
    By Melo in forum Security
    Replies: 4
    Last Post: 01-21-2011, 09:25 PM
  5. Different passwords on front-end & back-end?
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-07-2011, 09:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums