hello,
if u are using ADODB then use the following line
<ConnectionName>.BeginTrans
:
:
ur statements
:
:
<connectionName>.commitTrans
when the user wants to save changes then run
CommitTrans..if user want to cancel then run
RollbackTans.
All the lines after BeginTans are stored as undo
statements..they can be saved by commit trans ans
Cancled by RollbackTrans.
Also, use Connection Lock type as adLockPessimistic
ans CursorType as adOpenDynamic.
i hope this will resolve ur problem
--- "Ruel D. Bamba" <[EMAIL PROTECTED]> wrote:
>
>
> hi everybody !!
>
> can somebody teach me how to make a database
> application that will be
> used by multiple user and the data will be online
> anytime for an inquiry or
> editing. im using an access db and im having
> problems with my current
> application coz everytime they use it
> simultaneously, the first one to save
> the entry will get the data on the temporary table (
> i use temporary tables
> in case they cancel or do not want changes to take
> effect on the main table)
>
> please show me how to do this right.
>
> tnx in advance
>
> [Non-text portions of this message have been
> removed]
>
>
>
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
