Pak, saya masih pakai link table ke MS Access 2003, belum pakai SQL 
Server. Tolong pencerahannya...

Terima kasih sebelumnya,
Tio





Belajar Office <[email protected]>
Sent by: [email protected]
01/15/2010 08:28 AM
Please respond to belajar-access

 
        To:     [email protected]
        cc: 
        Subject:        Re: [belajar-access] Ganti isi message box bila ada 
Write conflict di 
multi user


 
Bpk menggunakan link table ke SQL Server ya? Dalam aplikasi multi user 
sebaiknya tidak perlu ada peringatan Write Conflict. Bila muncul 
peringatan tsb, maka ada yg belum diset dengan pas di properties tablenya. 
Bapak coba tambahkan field "timestamp" dengan data type "Binary" di table 
yg digunakan sebagai record source form tsb, namun sebelum form ini di 
jalankan, harap di refesh dulu Link Table nya.
 
Atau bisa juga Bpk tambahkan code di event save record sbb:
If Me.Dirty Then Me.Dirty = False
 
Masih ada cara2 lainnya, Bpk coba jalankan dulu saja salah satu cara 
diatas.
 
Thank's. 


From: "[email protected]" <[email protected]>
To: [email protected]
Sent: Fri, January 15, 2010 7:52:03 AM
Subject: [belajar-access] Ganti isi message box bila ada Write conflict di 
multi 
user

 

Dear Para Pakar Access, 

Adakah dari rekan milis yang ada pencerahan untuk pertanyaan saya ini ? 

Terima kasih banyak sebelumnya. 
Tio 

(Untuk update table dari table lain, saya masih dalam progress karena 
kebijakan kantor tidak bisa mengirim attachment, kecuali menerima . Mohon 
maklum) 

----- Forwarded by Tio Adi Bayu Adjie/SSB/PTTU on 01/15/2010 07:52 AM 
----- 

tio.ad...@ptssb. co.id 
Sent by: belajar-access@ yahoogroups. com 
01/14/2010 07:54 AM 
Please respond to belajar-access 
        
        To:        belajar-access@ yahoogroups. com 
        cc:         
        Subject:        [belajar-access] Ganti isi message box bila ada 
Write conflict di multi user



 


Dear Para Pakar Access, 

Bagaimana cara mengganti isi message box bila terjadi Write Conflict untuk 
multi user ? ini diperlukan supaya isi message box itu di pahami user. 
Yaitu message yang ada pilihan "Save changes",  "Abandon" ,  "Drop 
changes"
Trims, 
Tio 
============ ========= ========= ========= ========= ========= ========= 
========= 
This email is confidential.  If  you are not the  addressee tell the 
sender 
immediately  and destroy this  email without using,  sending or storing 
it. 
Emails are not secure  and may suffer  errors, viruses, delay, 
interception 
and amendment.  The Trakindo Group of Companies do not accept liability 
for 
damage   caused   by   this   email   and   may   monitor   email traffic. 

Unless expressly stated, any opinions are the sender's and are not 
approved 
by  the  Tiara Marga Trakindo  Group of Companies and  this email is not 
an 
offer, solicitation,  recommendation   or   agreement   of    any kind. 
============ ========= ========= ========= ========= ========= ========= 
=========

============ ========= ========= ========= ========= ========= ========= 
========= 
This email is confidential.  If  you are not the  addressee tell the 
sender 
immediately  and destroy this  email without using,  sending or storing 
it. 
Emails are not secure  and may suffer  errors, viruses, delay, 
interception 
and amendment.  The Trakindo Group of Companies do not accept liability 
for 
damage   caused   by   this   email   and   may   monitor   email traffic. 

Unless expressly stated, any opinions are the sender's and are not 
approved 
by  the  Tiara Marga Trakindo  Group of Companies and  this email is not 
an 
offer, solicitation,  recommendation   or   agreement   of    any kind. 
============ ========= ========= ========= ========= ========= ========= 
=========





=========================================================================== 
This email is confidential.  If  you are not the  addressee tell the sender 
immediately  and destroy this  email without using,  sending or storing it. 
Emails are not secure  and may suffer  errors, viruses, delay, interception 
and amendment.  The Trakindo Group of Companies do not accept liability for 
damage   caused   by   this   email   and   may   monitor   email  traffic. 
Unless expressly stated, any opinions are the sender's and are not approved 
by  the  Tiara Marga Trakindo  Group of Companies and  this email is not an 
offer, solicitation,  recommendation   or   agreement   of    any     kind. 
===========================================================================

Kirim email ke