Re: Please help with a serious issue
- From: "dave" <bracken_dave@xxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 14:26:13 -0600
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
.
- References:
- Please help with a serious issue
- From: dave
- Re: Please help with a serious issue
- From: Brian Bushay TeamB
- Please help with a serious issue
- Prev by Date: Re: Why all the connections?
- Next by Date: Re: Why all the connections?
- Previous by thread: Re: Please help with a serious issue
- Next by thread: Could not find installable ISAM
- Index(es):
Relevant Pages
|
