Hello!
Please be patient as I'm not sure the best way to phrase this question. My client has been using an Access database (split into FE and BE) for several years. The client now wants their own customers to submit data from a PHP powered website directly into the database. The client will be assigned a user name and password and validated upon sign-on.
1 - Can a website be used as a front-end? The dropdown down boxes will still need to be populated from existing tables and the new submission will need to be saved to the database.
2 - The backend is currently housed on the client's in-house server and will remain there.
3 - Can an OBDC connection string be used to link the website and backend together or is there a better method?
4 - Will an Access database be sufficient or does the whole thing need to be updated to SQL Server?
The long-term goal is that each client will have a portal where they can check on their job submissions, status, and run some reports of past jobs.
Any advice you all can offer would be appreciated. I can get back to the web-developers with specific questions.
Thank you!
Please be patient as I'm not sure the best way to phrase this question. My client has been using an Access database (split into FE and BE) for several years. The client now wants their own customers to submit data from a PHP powered website directly into the database. The client will be assigned a user name and password and validated upon sign-on.
1 - Can a website be used as a front-end? The dropdown down boxes will still need to be populated from existing tables and the new submission will need to be saved to the database.
2 - The backend is currently housed on the client's in-house server and will remain there.
3 - Can an OBDC connection string be used to link the website and backend together or is there a better method?
4 - Will an Access database be sufficient or does the whole thing need to be updated to SQL Server?
The long-term goal is that each client will have a portal where they can check on their job submissions, status, and run some reports of past jobs.
Any advice you all can offer would be appreciated. I can get back to the web-developers with specific questions.
Thank you!