Importing data from secured database with a password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a macro in a database that imports data from another database. The other database is secured with a password, so everytime I run the macro, I have to enter that password. I know there is code that I can put right in the macro that contains the other database's password right in it so I do not have to type it...I am just not able to get the code quite right. Can someone help

Thanks
Julie
 
Hi Julie,

Take a look at:
ACC2000: How to Use the OpenDatabase Method to Open Password-Protected
Databases
http://support.microsoft.com/default.aspx?scid=kb;en-us;209953

HOWTO: Automate a Secured Access Database Using Visual Basic
http://support.microsoft.com/default.aspx?scid=kb;en-us;192919

HOW TO: Open a Password-Protected Database Through Automation in Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;235422

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Importing data from secured database with a password
| thread-index: AcRJssY3XfX4HoitQ+6WliF2jcu9oA==
| X-WN-Post: microsoft.public.access.security
| From: "=?Utf-8?B?SnVsaWU=?=" <[email protected]>
| Subject: Importing data from secured database with a password
| Date: Thu, 3 Jun 2004 14:36:05 -0700
| Lines: 4
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:11155
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.security
|
| I am running a macro in a database that imports data from another
database. The other database is secured with a password, so everytime I
run the macro, I have to enter that password. I know there is code that I
can put right in the macro that contains the other database's password
right in it so I do not have to type it...I am just not able to get the
code quite right. Can someone help?

Thanks,
Julie
|
 
Hi Julie,

Use the solution in
http://support.microsoft.com/default.aspx?scid=kb;en-us;235422

If it's a macro you are trying to call in the password protected database
following the line

acc.OpenCurrentDatabase strDbName

Add the following

acc.DoCmd.RunMacro "the name of the macro"


NOTE: you can modify the code in the above article to have the 2nd instance
of Access that you are opening not visible by changing the line

acc.Visible = True

TO

acc.Visible = False

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Thread-Topic: Importing data from secured database with a password
| thread-index: AcRNoU31CJKPPmulQg+qtL1tBX+7Zg==
| X-WN-Post: microsoft.public.access.security
| From: "=?Utf-8?B?SnVsaWU=?=" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: Importing data from secured database with a password
| Date: Tue, 8 Jun 2004 14:41:06 -0700
| Lines: 5
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:11266
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.security
|
| I guess maybe I do not know as much about coding in Access as I claim to.
I have the logic you sent me on OpenDatabase and it appears to be
working...I guess my problem is I do not know where or how exactly to
execute the next step which would be to pull one of the tables from that
database into the one I am in. Currently, I have the TransferDatabase
command as part of a macro and when it gets to that step it prompts me for
the password of the database I am importing from...that is where I would
like to be able to have it just import the table and not prompt me. Can
you help or am I a lost cause?

Thanks,
Julie

|
 
Back
Top