Home
Search
 
What's New
Index
Books
Links
Q & A
Newsletter
Banners
 
Feedback
Tip Jar
 
C# Helper...
 
XML RSS Feed
Follow VBHelper on Twitter
 
 
 
MSDN Visual Basic Community
 
 
 
 
 
 
TitleUse a password protected phone database with DAO
DescriptionThis example shows how to use a password protected phone database with DAO in Visual Basic 6. The program uses the "pwd=" clause to specify the password.
KeywordsDAO, password, database, password protected database
CategoriesDatabase
 
Thanks to Shamsul Arifin.

This program lets you manage a phone list in a password protected Access database using DAO. The OpenDataBase subroutine uses the "pwd=" clause in the call to OpenDataBase to give DAO the password.

 
Const DbPass = "Gamal"

Public Sub OpenDataBase()
    Set MyDB = MyWS.OpenDataBase(DbFileName, _
        False, False, ";pwd=" & DbPass)
End Sub
 
See the code for other details. This program shows how to add, remove, update, and navigate through the data.
 
 
Copyright © 1997-2010 Rocky Mountain Computer Consulting, Inc.   All rights reserved.
  Updated