UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Multi Users Editing The Same Record At The Same Time, Access 2003    
 
   
ashraf_al_ani
post Oct 9 2016, 05:58 AM
Post#1



Posts: 84
Joined: 5-August 14



Hi all
I am using ms access 2003 as a front end and ms SQL server 2000 as back end
i have a problem that happens with multiuser they can update the same record when it is opened by more than one at the same time
how can i prevent other users from editing the record when it is opened by one user?
best regards
Go to the top of the page
 
dmhzx
post Oct 9 2016, 06:19 AM
Post#2



Posts: 7,033
Joined: 22-December 10
From: England


I THINK that with a SQL back end, you can lock the record. -- But don't know the code.
Go to the top of the page
 
ashraf_al_ani
post Oct 9 2016, 06:24 AM
Post#3



Posts: 84
Joined: 5-August 14



Hi thanks for reply
I thought if there is a code from SQL to prevent editing the record when it is opened but I have no idea if it can be done or no
please any idea?
best regards
Go to the top of the page
 
GroverParkGeorge
post Oct 9 2016, 07:47 AM
Post#4


UA Admin
Posts: 31,245
Joined: 20-June 02
From: Newcastle, WA


I'm not sure you even need to worry about this. SQL Server itself automatically locks records when a user begins to edit them. See also

.
Go to the top of the page
 
ashraf_al_ani
post Oct 10 2016, 05:27 PM
Post#5



Posts: 84
Joined: 5-August 14



thanks for reply
I tried to run the codes in the article but I didn't succeed
please any idea


and other question please is there ability to refresh the current record so I keep the screen of the refreshed record?
best regards
Go to the top of the page
 
GroverParkGeorge
post Oct 11 2016, 08:04 AM
Post#6


UA Admin
Posts: 31,245
Joined: 20-June 02
From: Newcastle, WA


What does it mean to say "...didn't succeed"? The code failed? It raised errors? You couldn't implement it? Or?

Please, more context regarding your question about refreshing the current record. Where, when, why?
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 05:34 AM