Coba anda bikin connection string menggunakan bantuan component ADODC.
Caranya :
-Tambahkan component Microsoft ADO Data Control di project anda.
-Masukan component tersebut kedalam salah satu form.
-Klik kanan pada component. pilih menu ADODC Properties.
-Pada property page, Tab General pilih Use Connection String. kemudian
klik tombol Build.
-Pada data link properties, Tab Provider, pilih Microsoft Jet 4.0 OLE DB
Provide.
-Pada Tab Connection, masukan Path database pada textbox 1. Select or
enter database name:
untuk isian 2. information to log on to the database, biarkan seperti
defaultnya. tidak perlu mamasukan password.
-Selanjutnya klik Tab All. pilih Jet OLEDB: Database Password. kemudian
klik tombol Edit Value.
masukan passord database anda.
- jika sudah selesai, buka kembali tab connection, kemudian lakukan test
connection dengan mengklik tombol Test Connection.
- Jika test koneksi sudah berhasil. Klik ok untuk menutup data link
properties.
- pada ADODC Property Page silahkan di copy connection stringnya.
Semoga membantu,
Thks,
On 8/5/2010 1:29 PM, Asral Sukma wrote:
yup,itu sudah sy ganti dengan password aslinya.
--- On *Wed, 8/4/10, Anez Story /<anez_st...@yahoo.com>/* wrote:
From: Anez Story <anez_st...@yahoo.com>
Subject: RE: [programmer-vb] open exclusive
To: programmer-vb@yahoogroups.com
Date: Wednesday, August 4, 2010, 5:51 PM
sebelum di jalan kan connection stringnya,
'pass' nya harus di isi dgn pswd database accessnya..br di
jalankan connection stringnya..
On Wed Aug 4th, 2010 5:52 AM EDT Asral Sukma wrote:
>saya sudah coba, muncul pesan "Provider connot be found. it may
not be properly installed",
>apakah ada yg harus saya instal terlebih dahulu?
>
>terima kasuh
>
>--- On Wed, 8/4/10, Andhi Y <dh...@cbn.net.id
</mc/compose?to=dhian%40cbn.net.id>> wrote:
>
>From: Andhi Y <dh...@cbn.net.id </mc/compose?to=dhian%40cbn.net.id>>
>Subject: RE: [programmer-vb] open exclusive
>To: programmer-vb@yahoogroups.com
</mc/compose?to=programmer-vb%40yahoogroups.com>
>Date: Wednesday, August 4, 2010, 11:54 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>Coba di connectionstring- nya seperti ini:
>
>
>
>ConnectionString = "Provider=Microsoft .Jet.OLEDB.
>4.0;Data Source= " & App.Path & "\SecureTA.mdb" &
>"; Jet OLEDB:Database Password=' " & pass &
>"';Persist Security Info=False"
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>From: Asral Sukma
><alsu...@yahoo. com>
>
>To: programmer-vb@ yahoogroups. com
>
>Sent: Wed, August 4, 2010 9:33:04 AM
>
>Subject: [programmer- vb] open exclusive
>
>
>
>
>
>
>
>
>
>
> salam buat semua
>
>
>
> saya coba bikin connection string untuk open database access,
tapi dapat
> pesan seperti dibawah :
>
>
>
> "Cannot start ur application. the work group information file is
missing
> or opened exclusively by another user"
>
>
>
> berikut code connection string nya :
>
>
>
> .ConnectionString = "Provider=Microsoft .Jet.OLEDB. 4.0;Data
> Source= " & App.Path & "\SecureTA.mdb" &
> ";Password=' " & pass & "';Persist Security
> Info=False"
>
>
>
> apakah ada yang harus ditambahkan pada connection string nya??
>
>
>
> mohon bantuan.
>
>
>
> terima kasih
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
