You cannot have two separate databases open in the same instance of Access. You can have linked tables from another DB or you can use the 'Shell' command to open the DB in another instance of Access: Private Sub CommandButton_Click() 'Open another database Dim PathNameOfDB As string PathNameOfDB="C:\Pathname\BDName.mdb" Shell "C:\Program Files\Microsoft Office\Office11\msaccess.exe " & "PathNameOfDB", vbMaximizedFocus Application.Quit ' closes current application so new DB is current. End Sub MDBMakers.com is a great source for Access and VBA solutions. Steve -- modified at 8:46 Friday 4th August, 2006

Are you trying to open a password protected access database from VB.NET? One thing to remember, if you have the database set to 'compact on close' the password window will re-appear. Steve

CEdit m_Edit; m_Edit.Create(ES_NUMBER|WS_CHILD|WS_VISIBLE|WS_BORDER,CRect(0,0,100,23),this,1); m_Edit.SetWindowText("123"); ---------------------------- m_Edit.ModifyStyle(0,ES_NUMBER); or change Number (ES_NUMBER) to true in window property form your Editbox

thank you verry much. it was helpfull:)

maybe it is some helpful to you http://www.codeproject.com/bitmap/jscdibdata.asp[^]