dear all i have a problem with my system with the following
i make point of sale system to big store using vb6 and access 2000 the store have four (4) computers 3 clients and one server i install the system in all the pc's and the 1 server and 3 clients the system is very good using but there is some problems i need you to help me
1- there is some orders not saved (maybe) duplicated in the order table so i remove the primary keys from all the tables but there is some items not saved i dont know why
for example i cash 1 and cash 2 save in the same time 2 orders one of the orders not saved all the item some items loose from the order but the price is right (the total of the order is right)
no problem in the prices in the form but in the data base some items not exits please i need your help
2- i use the exe server for all the client as shourt cut so they really use the exe file from the system .
3- is the big data let the network slow?
4- what can i do to store all the data to the master table and detail table
i.m ( i have two table one master and one details the master no any problem but the details not all the item save on it )
5 - i use ado programming
the network is work group i dont use ip address for this system