Can this error be avoided?

  • Thread starter Thread starter Cire via AccessMonster.com
  • Start date Start date
C

Cire via AccessMonster.com

Hi all, i've developed a query system using forms for my users. This 3rd
party system is more of a search/sort system, i.e. its read only and able to
export to excel but its does not allow updates to server data, the server is
based on a Ms-SQL backend, call this system A

The backend is actually a main server for the web application(System B) which
my users use to update data. They update various stuff, this software serves
more of a call centre kind of software where they see tickets assigned to
them, the problem, the requestor etc etc and then they proceed to resolve the
problem. however this software's reporting system isn't good enough and thus
i had to develope a separate solution as menitoned in the 1st paragraph.Thats
for the background now for the problem:

If 1 user is updating a ticket through system B and ano user uses system A to
query the server, an error occurs, i believe its because there is a conflict
since one is trying to update and the other trying to retrieve, and the
system isn't fast enough to detect that right? If so other than telling my
users not to do both things at one time, are there other solutions? would the
problem be access or another frontend software would result in the same
problem? and if this in the wrong forumn could some admin move it to the
correct one.

Thanks
Eric
 
Alex said:
Hi,
perhaps you set locks on a table when you either read data from system A or
update from system B, so try to remove these locks. Also, make sure that you
open database in shared mode in both cases
Hi all, i've developed a query system using forms for my users. This 3rd
party system is more of a search/sort system, i.e. its read only and able
Click to expand...
[quoted text clipped - 30 lines]
Thanks
Eric
Click to expand...
Click to expand...

Hi Alex, what do u mean by shared mode? and system B is not designed by me
nor is it an access form so i have no control nor editing rights over it, its
was designed by the company that supplied the entire suite of software. As
for locks, i think i have to ask my db adminstrator about that, tks for
pointing it out.
 
Hi,
well, if you can read DB from both applications same time - then both
systems open DB in shared more. Non-shared, or Exclusive - is when you can
open DB from only one application or user
So, perhaps this is a locks issue

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Cire via AccessMonster.com said:
Alex said:
Hi,
perhaps you set locks on a table when you either read data from system A
or
update from system B, so try to remove these locks. Also, make sure that
you
open database in shared mode in both cases
Hi all, i've developed a query system using forms for my users. This 3rd
party system is more of a search/sort system, i.e. its read only and
able
Click to expand...
[quoted text clipped - 30 lines]
Thanks
Eric
Click to expand...
Click to expand...

Hi Alex, what do u mean by shared mode? and system B is not designed by me
nor is it an access form so i have no control nor editing rights over it,
its
was designed by the company that supplied the entire suite of software. As
for locks, i think i have to ask my db adminstrator about that, tks for
pointing it out.
Click to expand...
 
Back
Top