Kalau ODBC saya tdk pakai. Tadinya saya assume anda pakai Native OLE DB => Access Project. Solusi yg saya kasih untuk koneksi OLE DB.
On Thu, Mar 5, 2009 at 4:19 PM, Abdurrahman Suryadi < [email protected]> wrote: > table-table yang ada sudah ngelink ke ODBC sourcenya GDB > > Program yang di pakai di client : Microsoft Access MDB > OS client : Windows XP SP2 > Nama Server : GDCSRV > OS Server : windows Server 2000 > DBMS : SQL Server 2000 > Nama Data Source di ODBC : GDB > Nama Database : DataCenter > User : Ahmad > Password : santri > > Object di Form: > 2 text box (txtUser dan txtPassword) > 1 Commdand Button (btnOK) > > Sintax di on Click btnOK: > > Private Sub btnOK_Click() > pServer = "GDCSRV" > pUser = Me.txtUser > pPwd = Me.txtPassword > pDB = "DataCenter" > bc = "PROVIDER=SQLOLEDB.1;" & _ > "PERSIST SECURITY INFO=TRUE;" & _ > "DATA SOURCE=" & pServer & ";" & _ > "USER ID=" & pUser & ";" & _ > "PASSWORD=" & Nz(pPwd, "") & ";" & _ > "INITIAL CATALOG=" & pDB > CurrentProject.OpenConnection (bc) > End Sub > > ketika klik btnOK, muncul peringatan: "the expression you entered refered > to an object that is closed or doesn't exist" > > Tolong berikan pencerahan > Terima kasih banyak > - Show quoted text - > > > > ------------------------------------ > > SPAM IS PROHIBITEDYahoo! Groups Links > > > > -- [Haer Talib] MVP Office Access Meet me at www.RumahAccess.com =>
