Sunday, 11 August 2013

Visual basic multi-user database updating [on hold]

Visual basic multi-user database updating [on hold]

So I've written a business application to keep track of call logs for a
small group in a call center (10-15 agents). It uses a ms Access (.mdb)
database on a share drive to keep agent login info and all the call logs.
I'm using oledb coding, and using data.tables("Agents").Rows.Add() to add
new agents, which works fine since I'm the only one that will be updating
the agents. I'm wondering if 2 agents try to update the call log table at
the same time if it will cause problems. As few people will use it at this
time, it's unlikely that 2 agents will try to save a call log at the same
time, but as it goes on more and more agents will use it. Since the table
is imported into a local dataset then sent back when done adding the new
information, if 2 agents did so at the same time, could this cause me to
loose one of the rows of data?
Is there a different method i should use to add rows for the call logs?

No comments:

Post a Comment