Results 1 to 2 of 2
  1. #1
    snoopy2003 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    72

    Upldate password protect linked table

    Hello,



    I wish to update a link to protected table (DB).
    I use tdf.Connect = ";DATABASE=" & strNewPath to set the connection
    but I do not know how to pass database password parameter.

    Can you help me ?

    Code:
    ...
    For intCount = 0 To dbs.TableDefs.Count - 1
    Set tdf = dbs.TableDefs(intCount)
    If tdf.Connect <> "" Then
    Me.lblMsg.Caption = "Refreshing " & tdf.Name
    DoEvents
    tdf.Connect = ";DATABASE=" & strNewPath
    tdf.RefreshLink
    End If  ' tdf.Connect <> ""
    Next intCount
    ...
    Thank you

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    What do you mean by 'protected table DB'? Do you mean MSAccess security was implemented on the mdb/accdb?

    If it uses an mdw file, this may not be possible. I can't say for sure though since I never needed to do this.

    Perhaps this may help: https://www.accessforums.net/code-re...-php-7692.html

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

Similar Threads

  1. Password Protect Buttons on Forms
    By Desstro in forum Forms
    Replies: 13
    Last Post: 08-24-2012, 05:04 PM
  2. Replies: 3
    Last Post: 11-10-2011, 03:54 PM
  3. Password Protect Forms
    By jlclark4 in forum Security
    Replies: 3
    Last Post: 01-25-2011, 04:26 PM
  4. readonly password protect
    By mlgehle in forum Security
    Replies: 1
    Last Post: 03-13-2010, 08:59 PM
  5. Password Protect Forms
    By Robert M in forum Programming
    Replies: 3
    Last Post: 01-15-2010, 01:50 PM

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