vishnu bobade

• Sep 8th, 2005

 

The Catalog object is the container for the data definition collections (Tables, Procedures, and Views) and the security collections (Users and Groups). This differs from DAO, in which the Database object contains the data definition collections and the Workspace object contains the security collections. Each Catalog object is associated with only one Connection, whereas a DAO Workspace may contain multiple Databases. 
 
Sub DAOOpenSecuredDatabase() 
 
Dim wks As DAO.Workspace 
Dim db As DAO.Database 
 
DBEngine.SystemDB = _ 
"C:Program FilesMicrosoft OfficeOfficeSYSTEM.MDW" 
 
Set wks = DBEngine.CreateWorkspace("", "Admin", "MyPassword") 
Set db = wks.OpenDatabase(".NorthWind.mdb") 
 
db.Close 
wks.Close 
 
End Sub 
 

Gayathri

• Dec 4th, 2006

 

Workspeace - An area can hold one or more database