Website input form into Microsoft Access Backend - mdb.
Microsoft Access 2003.
Website input page/form.
Looking for solutions that take an Online application and converts into format for Microsoft Access DB.
Project is in 2 parts.
1. Sample customer input webpage. Submit form.
2. File arrives in .csv format. Either email address or suggestions welcome. Please explain options and security/privacy implications of delivery method.
3. Load .csv format of customer's application details and load to "check form".
4. DB users to check customer details on Access form -> "LOAD" inputs into backend table.
Note: this project Part 1 & 2 is for an application that is a non-relational db. Hence, no need for links.
Please explain or propose a solution for a simple relational database online data entry.
ie PersonalDetails Table & FamilyDetails Table linked via FamilyID. Many PersonalIDs to one FamilyID.