Database Transactions ?

[vikramonline]

I have password protected site where the authorised users can update the database.
The problem is that there can be a scenario where many users are trying to modify a single record.This can really create problems.

The question is that how can we solve such sort of problem.
Is it a question of maintaining transactions??
The database used is MS-Access.

Please suggest

 

[mwolf00]

Depending on the application, you might want to add a table of items that are currently "checked-out" for updating. The choose a timeframe for how long they are out (and whether that user's session is still active) so that only one editable version is out at once (others get read-only access)

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[vikramonline]

mWolf00,
Thanx for ur help and sorry for the late response.
Whatever u said I had already a fair idea of that but I dont know how to implement it.

Any suggestions or code will be a great help.
Thanx.