Results 1 to 2 of 2
  1. #1
    adnankaysar is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    1

    DoCmd.TransferDatabase Storelogin = False not working

    Linking tables from other access database and not to save the login information I have used the storelogin = false in the code but after the procedure executed and the tables are linked in the current database the password can be found in the Connect column of MSysObjects for the tables linked. The code is below, cant find what's going wrong here.Thanks
    Code:
    Dim db_ext1Gb As DAO.Database
    Set db_ext1Gb = DBEngine.OpenDatabase(srcPath & "\" & "ext1Gb.accdb", False, False, ";pwd=" & strPassword)
    For Each tdf In db_ext1Gb.TableDefs 'Loop through all the table in the external database
        If Left(tdf.Name, 4) <> "MSys" Then  'Exclude System Tables
                  On Error Resume Next
                  DoCmd.TransferDatabase acLink, "Microsoft Access", srcPath & "\" & "ext1Gb.accdb", acTable, tdf.Name, tdf.Name, , False
                  TableDefs.Append tdf
                  tdf.RefreshLink
         End If
         Next tdf
         db_ext1Gb.Close


  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Unfortunately the storelogin argument is for ODBC links only, see the link below:

    https://msdn.microsoft.com/en-us/vba...-method-access

    Cheers,
    Vlad

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

Similar Threads

  1. DoCmd.Close Not Working
    By kdbailey in forum Access
    Replies: 6
    Last Post: 12-11-2013, 07:35 PM
  2. DoCmd.OutputTo not working
    By arunkumar213 in forum Access
    Replies: 1
    Last Post: 09-08-2011, 10:41 PM
  3. Form combo box not working with AllowEdits = False
    By jgelpi16 in forum Programming
    Replies: 3
    Last Post: 02-04-2011, 05:08 PM
  4. DoCmd.TransferDatabase acImport Issue
    By remingtont in forum Programming
    Replies: 0
    Last Post: 11-12-2010, 03:59 PM
  5. getting error using docmd.transferdatabase
    By haggisns in forum Import/Export Data
    Replies: 1
    Last Post: 11-02-2010, 08:18 AM

Tags for this Thread

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