+ Reply to Thread
Results 1 to 3 of 3

How to Import a password protected MS Access with a static password to Excel

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to Import a password protected MS Access with a static password to Excel

    Hi everyone hope there is someone who can help me.
    I have a user form and a password protected ms access database..the access is my database and i want to import the data from it and place those data to an excel sheet...i have a code for that and it works perfectly...but my problem is the password in the database is not constant and it will be change every month what i want to do is i want to make a user form that has a TEXT BOX for password to be supply and a command button to execute the import and read the password supply in the TEXT BOX....hope you can help me for these Ive been looking in the internet for the possible answer but sad to say there is no same problem that being answer. thanks..

  2. #2
    Registered User
    Join Date
    02-24-2013
    Location
    philippines
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to Import a password protected MS Access with a static password to Excel

    Please Login or Register  to view this content.
    by the way this is the code Ive been using..and it works great but my problem is the password in the database is need to be change every month.
    Last edited by alansidman; 08-09-2014 at 06:15 PM. Reason: code tags added

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,512

    Re: How to Import a password protected MS Access with a static password to Excel

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PowerPivot unable to import password protected Access file
    By Ichigo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-02-2012, 09:35 PM
  2. Excel export to password protected Access DB
    By Kinez101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2011, 11:14 AM
  3. Replies: 0
    Last Post: 10-12-2005, 01:05 PM
  4. Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  5. Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1