Re: Please help with a serious issue

Thank you for your reply. I will try what you suggest. But what do i do 
about the situation where the software filters the database on one users 
machine, but then another user also applies a different filter. This seems 
to mess up the first users filtered results. I thought that telling the 
tables(etc) to use client-side cursor meant that a copy of the server data 
is placed locally on machine. If that was the case why would the second 
users filter ruin the first? Am i mistaken as to how that works?

Thanks again,
David L. Bracken


"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message 
news:3pb0u1ld4ohf9cicemnu7h1npnf99lc6t0@xxxxxxxxxx
>
> Are you using explicit transactions in your that are open while the user 
> edits
> data?  If you are that is your problem.
> Otherwise if your users are not trying to edit the same record I don't see 
> a
> reason for multiple users to create a problem that corresponds with the 
> error
> message you are getting.
>
> My guess is that it has something to do with you application posting a 
> record
> and then going back and re-editing that record with out requerying the 
> data.
> The default for ADO to generate update code is to use all of the original 
> values
> from fields in a record to locate the record in the database to be 
> updated.
> After an update if the value in the database doesn't exactly match the 
> value in
> the updated record on the clientside cursor a subsequent update will fail.
> DateTime fields are prone to this problem if they contain miliseconds.
> You can try switching updates to just use the key field value for 
> updating.
>
> to set update to only use key fields use
> ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;
>
> Your choices are adCriteriaKey, adCriteriaAllCols (BDE's default),
> adCriteriaUpdCols (ADO's default) and adCriteriaTimeStamp. Search the
> Platform SDK for more details.
>
> http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q190727&GSSNB=1
>
>
>
>
>>It is random, and i dont know for sure. There are primary keys in all my
>>tables. The problem seems to be that access doesnt handle multiple users
>>hitting the same spots on the db at the same time very well. I was using
>>filters to filter the table to the need record, but then the next person 
>>to
>>come along gets the wrong data because of the filter applied for the first
>>user.
>>
>>Here is the scenario, and i dont know how to set this up properly , so any
>>help you can give would be greatly appreciated.
>>
>>There are at any given time 3 users using my software to take orders for
>>customers, or invoice the completed orders, etc.
>>User 1 selects customer 1. The credit card table is filtered to that 
>>account
>>so that the invoice which points at the cctable has the correct data. Now
>>user 1 does not commit this invoice.(has to walk away from computer or
>>something).
>>User 2 selects customer 2, and credit card table is again filtered, and 
>>when
>>user1 comes back the cc data is now wrong.
>>
>>What i basically need to know is how to allow multiple users to use the 
>>same
>>server db for all the clients. i do not want to have to have them do
>>everything locally and then write some serious code for updating the 
>>server
>>with thier local stuff. I have the Adoconnection and all my tables
>>cursorlocation set to client side and cursor type to static.(i tried 
>>dynamic
>>as well, but no change). How do i allow writing and retrieveing of data
>>across multiple clients without them tripping over each others data?
>>I am seriously pulling my hair out here, i am a novice at db programming,
>>but i did not think this would be so difficult. things that keep happening
>>like, credit card data is shown correctly in the software but when the
>>invoice is printed it is the wrong credit card number.
>>The main tables of this software is:
>>Products table - holds all products, prices etc.
>>Customer table - Customers info including address contact etc.
>>Customer Shipping - Holds all possible shipping addresses for each client.
>>They can have multiple
>>Credit Card table - Holds credit card data for customers, these may also
>>contain multiple for each customer
>>Orders table - holds the information for the order
>>Lineitems table - holds info for each line item related by order number
>>Invoice table - invoice info which relates to order table and lineitem 
>>table
>>
>>at one point or another, every one of these tables is used to get through 
>>a
>>single order, and there are 3 users doing this simultaneously.
>>
>>If we decided to switch db's would the free SQL server version be
>>sufficient, and would it automatically solve my issues?
>>
>>sorry for all the noob questions.
>>Thanks in advance,
>>David L. Bracken
>>
>>"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
>>news:4mltt19p88jj9lrq9k2d0dad1a3b602l91@xxxxxxxxxx
>>>
>>>>I have written an order entry/inventory/reporting app.
>>>>I am using an ADOConnection component with many ADOTables. The software 
>>>>is
>>>>run from the client machines and connects to an Access db on the server.
>>>>I keep getting "row cannot be located" message, but i am not using any
>>>>triggers that i am aware of. I only use one ADOQuery component to empty 
>>>>a
>>>>temp table.
>>> Are you getting this message every time you try to update a record or 
>>> only
>>> some
>>> of the time?
>>> Does it just happen after you have inserted a new record and then go 
>>> back
>>> to it
>>> and change it?
>>> Do you have primary keys on your tables?
>>> --
>>> Brian Bushay (TeamB)
>>> Bbushay@xxxxxxxxx
>>
>
> --
> Brian Bushay (TeamB)
> Bbushay@xxxxxxxxx 


.

Relevant Pages

  • Re: Please help with a serious issue
    ... does a filter statement on an adotable happen on the client machine or the ... >>User 1 selects customer 1. ... >>server db for all the clients. ...
    (borland.public.delphi.database.ado)
  • Re: Showing records in a Sub form based on TWO combo boxes on Main
    ... on my first Combo which is where I select the Customer. ... It is this value that i want to firstly filter my form on ... When I select "Air New Zealand" I immediately getting a Runtime Error 2448, ... Private Sub cboFilterCust_AfterUpdate ...
    (microsoft.public.access.forms)
  • Re: Strange behavior with views
    ... >> with customer data I can open a new form with orderlines by ... >> doubleclicking on the customer info in the grid. ... >> parameter as a filter so i use the following code: ... >> - all open items ...
    (microsoft.public.fox.vfp.forms)
  • Re: Showing records in a Sub form based on TWO combo boxes on Main
    ... So (Customer Number) has to be entered as ... It is this value that i want to firstly filter my form on ... Private Sub cboFilterCust_AfterUpdate ... the filter string from whichever comboare not blank. ...
    (microsoft.public.access.forms)
  • Re: Is Relational Hierarchy Possible with Excel
    ... the easiest is to turn on the macro recorder and apply the filter manually. ... >>> levels down the Customer hierarchy as follows: ... once a desired Contract has been ...
    (microsoft.public.excel.programming)