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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1

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

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

"Cire via AccessMonster.com" <u18563@uwe> wrote in message
news:5e905cb6f556d@uwe...
> 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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200604/1

Alex Dybenko wrote:
>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
>[quoted text clipped - 30 lines]
>> Thanks
>> Eric

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1

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" <u18563@uwe> wrote in message
news:5e97d3031a0d8@uwe...
> Alex Dybenko wrote:
>>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
>>[quoted text clipped - 30 lines]
>>> Thanks
>>> Eric
>
> 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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200604/1