tnx for the answer, i think it will help me. can i add the
<connectionname>.begintrans upon form load ?
One more favor, can anybody give me a sample code on connecting, saving to a
database that will be used by multi user and will be online for inquiries
and editing. pardon my ignorance, I'm really confused with this coz i'm
using a temporary table where the data is stored while the users edit or add
records, then transfer them to the main table upon saving. problem is if
more than one user uses the same temporary table, the first one to save or
close the form will zap the temporary file, leaving the other user without
any records.
anybody please give me a sample code on databases applications for multiuser
tnx in advance
-------Original Message-------
From: [EMAIL PROTECTED]
Date: 05/05/04 21:50:19
To: [EMAIL PROTECTED]
Subject: Re: [vbhelp] How to make itt multiuser
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 the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM
---------------------------------------------------------------------~->
'// =======================================================
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/
