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

**diodel** · 08-08-2014, 03:26 AM

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..

**diodel** · 08-08-2014, 03:30 AM

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.

**alansidman** · 08-09-2014, 06:15 PM

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.)

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

PowerPivot unable to import password protected Access file

Excel export to password protected Access DB

How to import data from a password protected Access DB into Excel.

how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab.

[SOLVED] how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab.

Bookmarks

Bookmarks

Posting Permissions