Data overlapping in Microsoft Access 2003

Question

1.00/5 (2 votes)

See more:

Hi friends,
My name is Niranjan, i have a small project in VB 6.0 AND Access Database...

I have 3 systems connected in LAN, and the project is running in all these 3 systems.
whats happening is when all three users are saving the record at a time, the records in the database are overlapping with the same bill number..

Please help to get me out of this problem.

Thank You.,

Posted 4-Dec-13 4:15am

NIRANJAN V A

Add a Solution

Comments

Maciej Los 4-Dec-13 10:24am

Share your code. We can't help you without it, because we didn't see your screeen and we can't read in your mind.
We need more details about saving data. Please, use "Improve question" widget.
;)

AlexDpars 4-Dec-13 11:47am

You should try to make your bill number column auto incremented. Doing that will ensure you to have a different bill number on each row. If this solution could be helpful for you I will post the complete solution.

ZurdoDev 4-Dec-13 12:28pm

You need to implement some concurrency rules.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2013-12-10T09:50:00

You have several options ... here are just a few

With a nod to RyanDev - try implementing some concurrency rules ... have a look at this discussion on mdb concurrency[^]

With a nod to AlexDpars ... you could have a column that auto-increments and use that for your invoice number ... this link is old but still applies fields that generate automatically[^]. You might want to reset the number after trying it out ... how to reset an Autonumber field[^]. Be aware that many people do not like Autonumber fields - however, I've used them successfully and frequently.

You could upgrade to a more robust multi-user database - there are several offerings out there but you will probably still have to consider building in concurrency rules - the advantage that many other RDBMS will bring is being able to use Triggers/Stored Procedures to implement those rules.