Ok, I need some advice from all you access wizards out there. I will try to explain what I am trying to do and hopfully you can put me on the right road to complete this task.
I have a database, with tables to store information along with a couple of lookup tables for some computations, forms for input and reports for printing the data.
1. We do not want to distribute the lookup tables to the customer for we do not want the customer to see the data.
2. The data that we store for the customers is stored in two tables, this includes the calculations based on the lookup tables.
3. The data in the lookup tables will change from time to time.
4. The customer will be able to input items and then they will send the database back to us for the computations and then we will send the database back to them with the updated items.
The way that I see this is to have two databases; one for the customer and a master that we have were we can change the data in the lookup tables (when needed), and recalculate the answers based on the information input by the customer in the customers database. Then send the customer databases back to the customer.
Question is what would be the best way to do this? We would need to append (hopefully automated, maybe in visual basic code or macro) the customers new data with the data that is already there. Is a resyncing the database an option and how would it be done?
Ideas?
I have a database, with tables to store information along with a couple of lookup tables for some computations, forms for input and reports for printing the data.
1. We do not want to distribute the lookup tables to the customer for we do not want the customer to see the data.
2. The data that we store for the customers is stored in two tables, this includes the calculations based on the lookup tables.
3. The data in the lookup tables will change from time to time.
4. The customer will be able to input items and then they will send the database back to us for the computations and then we will send the database back to them with the updated items.
The way that I see this is to have two databases; one for the customer and a master that we have were we can change the data in the lookup tables (when needed), and recalculate the answers based on the information input by the customer in the customers database. Then send the customer databases back to the customer.
Question is what would be the best way to do this? We would need to append (hopefully automated, maybe in visual basic code or macro) the customers new data with the data that is already there. Is a resyncing the database an option and how would it be done?
Ideas?
