I am Rupesh & I am new to this forum.
I am trying to build a tool in excel which can update database maintained in access.
There will be 3 to 4 user for this excel tool which will be connected to one access database.
The excel will act as the front end tool & access as a backend tool.
I want excel VBA to perform 3 things:
1. It will update data in access based on 2 column which will act as a unique code.
2. It will add any new row if the data doesnt match with previous unique code.
3. If the user wants to delete perticular row / range then it will be deleted from database also.
Below sample of table:
Country Product code Sub-Brand Mfg Base
Russia SRU030008869020137 Syrups Own
Russia SRU030008869020141 Syrups Own
Russia SRU030008564220158 Tablets Own
Russia SRU030008564220258 Tablets Own
Russia SRU030008564220558 Tablets Own
USA SRU030008869020137 Syrups Own
USA SRU030008869020141 Syrups Own
USA SRU030008564220158 Tablets Own
USA SRU030008564220258 Tablets Own
USA SRU030008564220558 Tablets Own
1st two column will act as a unique key.
We cannot use a replacement code since there will be multiple user working on different region, replacement option can change or erase others database.
Thanks for the help in advance.