PC Review


Reply
Thread Tools Rate Thread

Connect the ”fe” to the encrypted ”be”

 
 
BrunoKP
Guest
Posts: n/a
 
      21st May 2009
I have asked before, but never found a useful solution, so please.

I want to connect the ”fe” to the encrypted ”be”, and I have tried with this
code:
Public Sub OpenDB()
Dim ServerFile As String
Dim db As DAO.Database
Dim ws As DAO.Workspace

Set ws = DBEngine.Workspaces(0)
ServerFile = "d:\home\data\ATR\Tabeller\ATR_be.accdb"
Set db = ws.OpenDatabase(ServerFile, False, False, "MS Access;pwd=be")
‘ db.Close
End Sub
My problem is that I don’t know from where I should call OpenDB when opening
the ”fe”, in order to connect to the ”be” and maintain the connection during
the whole session.
I’m also in doubt if I have to use db.Close.
I'm still new in Access as you may notice :-)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect the ”fe” to the encrypted ”be” BrunoKP Microsoft Access VBA Modules 10 21st May 2009 04:13 PM
Using and existing Yahoo e-mail on Outlook 2007. ENCRYPTED CONNECT Platinum Auto Service Plus Microsoft Outlook Installation 3 21st Nov 2008 09:04 PM
Backing up Bitlocker Encrypted Drive Equals Not Encrypted markbyrn Windows Vista Security 4 19th Mar 2007 02:33 AM
Non-encrypted message detected as encrypted =?Utf-8?B?Y3N0ZWFkaGFt?= Microsoft Outlook Discussion 0 28th Jul 2006 04:56 PM
Re: Reinstaled, Lost profiles, encrypted files left encrypted Jupiter Jones [MVP] Windows XP Security 0 3rd Jul 2003 04:07 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:59 AM.