Koding lengkapnya gimana???
Biasanya yang koneksi dbnya di akses mesti ada passwordSebagai contoh gwe punya
begini :
Private Sub Database()
PathTemp = "C:\HRD\TempTransSQL.mdb"
PathMaster = "C:\HRD\TempMasterSQL.mdb"
''Konek Lokalan
FileCopy "D:\HRD\Database\TempTransSQL.mdb", PathTemp
FileCopy "D:\HRD\Database\TempMasterSQL.mdb", PathMaster
vCnTrans = "Driver={MySQL ODBC 3.51 Driver};Server=192.168.2.6;" & _
"Port=3306;Database=namadatabase;User=namauser;Password=password;Option=3;"
vCnTemp = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source='" & PathTemp & "';" & _
"Persist Security Info=False"
vCnMaster = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source='" & PathMaster & "';" & _
"Persist Security Info=False"
end sub
Regards
Gege Nugroho
--- On Mon, 8/3/09, lidwina oktavianty <lidwina_o...@yahoo.com.hk> wrote:
From: lidwina oktavianty <lidwina_o...@yahoo.com.hk>
Subject: [Programmer-VB] Help : Filecopy error: Permission denied
To: "VB" <programmer-vb@yahoogroups.com>
Date: Monday, August 3, 2009, 2:02 PM
Teman2, mohon bantuannya.
Aku ingin backup database di vb. Aku pake database access 2003 dengan ada
password di database nya.
Codingnya spt ini:
dirawal = "D:\Data\Toko. mdb"
dirakhir = "D:\Data\Backup\ TokoBackup. mdb"
FileCopy dirawal, dirakhir ==> error : Permission denied
Dimana ya salah nya?
Thx,
Okta.
Send instant messages to your online friends http://uk.messenger .yahoo.com
