473,396 Members | 1,853 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

MS Access DAO multi-user updating problem

1
Hi all,

I have an application developed in MS Access and using DAO and running in multi-user environment. It is not a Web application, just the users are sharing data source. My problem is when more than one users are working on same record they are overwriting each other, in another word if a record has been deleted or updated by other users since the user retrieved the record and the user without realizing the changes and update the record again!

Could anyone give me a clue how to solve this problem?

Thanks in advance

Rossy
Oct 25 '06 #1
1 1614
jimatqsi
1,271 Expert 1GB
You have to look for the options about record locking. Under Tools, go to Options and the Advanced Tab. Set your default to lock the edited record. You also have this as a property option on forms.

Jim
Oct 25 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Diane Yocom | last post by:
Has anybody ever seen or written code for ASP that would mimic Access' multi-column combo box? Specifically, I have a drop down box that lists about 100 five-digit codes. Each of these codes has...
4
by: MSD | last post by:
I am running a report that uses a query as its record source and opens a form collecting beginning and ending item numbers to feed to the query. This works, but now I'm trying to use the result of...
41
by: Ruby Tuesday | last post by:
Hi, I was wondering if expert can give me some lite to convert my word table into access database. Note: within each cell of my word table(s), some has multi-line data in it. In addition, there...
13
by: marslee | last post by:
One of the my professor gave final question like this "How to use Access database in .Net enivronment to keep track of data?" I have no idea what it is about since he never taught about .NET in...
24
by: Kavya | last post by:
int main (){ int a={{1,2,3},{4,5,6}}; int (*ptr)=a; /* This should be fine and give 3 as output*/ printf("%d\n",(*ptr)); ++ptr;
7
by: Stephen Martinelli | last post by:
Can anyone tell me why this statement works with sql server with VB.net but crashes when run against a access mdb?....What do I need to change here guys? Update tblInvoice set ar_totalPaid =...
1
by: crystalgal | last post by:
Hello. I am tring to create a form that multi people use perhaps at the same time to enter daily counts for their production output. Scenario: There is 10 offices. I created 10 tables named after...
3
by: jim | last post by:
Each night, a scheduled task copies certain information from an MS Access db to a MySQL db that serves as a data warehouse. I would like to begin replicating multi-value fields from Access to...
3
by: needanswer | last post by:
Can I save values from the multi same form? How? Sample: on this form - one datagridview, one textbox, one combobox. Thanks.
6
by: Jiujing | last post by:
I need to use this tabbed form. Some of the select fields in one tab is the same as those in the other. How do I change the selection in tab 1 and get the same field in tab 2 changed? Please see...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.