dear developers,
i have an issue that bother me for 2 days.
im working at the service company, repairing and maintenance used cars.
u c, there’re gate officers( in and out ), finance mgt, accounting and public relation/customer service officers. but since the pr/cso had left, the boss want to replace him with a website.
so everytime the gate officers input data ( they’re using ms access ), the finance and the accounting will have the report. Then The boss wants the website to be dynamic. He wants it to be able to provide data to the customers about what repairing we have done to their cars.
For example,
we have 300 customers. All of them who has register will be given username and password. so they only need to go to the website.
we already have a static web on an apache hosting. so the suitable must be mysql for database.
1. how can it be done? how to colaborate ms access and mysql?
2. is there a script available to update automaticly from gate to the website?
thx and regards