Re: [Programmer-VB] mengakses database berpassword yang dibuat dg access

Padu Arsana W Mon, 13 Mar 2006 19:10:25 -0800

Coba pake cara ini :

Public CN As ADODB.Connection

CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= app.path &"\test.frr";Persist Security Info=False;Jet OLEDB:Database Password=111"

Salam,

Padu Arsana I Wayan

Nusa Penida, Klungkung - Bali

Robby <[EMAIL PROTECTED]> wrote:

boleh tau database aksesnya versi berapa?

trus udah pernah dicoba kalau tanpa password?

----- Original Message -----

From: nunu nugraha

To: [email protected]

Sent: Tuesday, March 14, 2006 7:11 AM

Subject: [Programmer-VB] mengakses database berpassword yang dibuat dg access

Dear rekan sekalian,...

mau minta tolong nih... saya lagi belajar vb 6. Saya pake access untuk bikin database-nya.

- database dibuat dg memakai access

- database memakai password 111

- database diubah ext file-nya dari tes.mdb menjadi tes.frr. Jadi aplikasi menggunakan database yang sudah diubah ext file-nya

- mengeset ODBC Data Source sebagai mana mestinya.

- Memakai XP

kode program :

Public cn As ADODB.Connection
Public rs1 As ADODB.Recordset
Public rs2 As ADODB.Recordset
Public rschek As ADODB.Connection

Private Sub Form_Load()

   Set cn = New ADODB.Connection

   cn.CursorLocation = adUseClient

   cn.ConnectionString = "Provider=microsoft.jet.oledb.4.0; Data So! urce= tes; ID=admin; password=111"


   cn.Open App.Path & "\tes.frr"
   Set rs1 = New ADODB.Recordset
   rs1.Open "select * from DataSiswa", cn, adOpenDynamic, adLockOptimistic

End Sub

permasalahan :

1. Selalu muncul error :

Run-time error '-2147217843 (800400e4d)'

Not a valid password.

Apa yang harus saya lakukan ?

2. Jika sekiranya ada cara lain, gimana caranya?

Terima kasih atas bantuan rekan2 sekalian.... Semoga Tuhan membalas kebaikan rekan2.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Matur suksma,

Padu Arsana W
Penida Island, Klungkung - Bali

Yahoo! Mail
Use Photomail to share photos without annoying attachments.

Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer

SPONSORED LINKS

`Programmer`	`Indonesia`	`Basic programming language`
`Computer programming languages`	`Programming languages`	`Java programming language`

YAHOO! GROUPS LINKS

Visit your group "Programmer-VB" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [Programmer-VB] mengakses database berpassword yang dibuat dg access

Kirim email ke