Take care,
Mike the Plumber
Sac City Plumbing
Phone: (916) 837-2211
hi Mike,
I've had good success back-ends on Azure -- then Access can get to it too. You'd need a could interface for your field people unless they can use remote desktop to get to a computer that's running Access. Optionally, you can use email and direct all their responses to a local mailbox that Access can link to, parse message, and get data.
kind regards,
crystal
Hi Mike
Access was never designed to handle cloud database structure. I've seen work-arounds that are so complex they are almost impossible to maintain. Many developers have built such monsters and regretted it later as Access is not the platform for such a system. I would start with a database in SQL Server hosted In the cloud with maybe something like Office 365 as the base.
Regards,
Bill Mosca
From: michael simpson via groups.io <saccity101=yahoo.com@groups.io>
Sent: Monday, May 31, 2021 5:36 PM
To: MSAccessProfessionals+owner@groups.io
Subject: [MSAccessProfessionals] I use MS Access in the office, how should I send work orders out to the field.....
Good day, I use MS Access as my business management system... I have a primary file at my home office.. I would like to be able to send, a short file file to the worker in the field, Perhaps a comma separated string (value), for the work order that can be updated in the field and then the updates pulled into my main database.. The ideal would be something that can be updated on a smart phone...
Any ideas on where to start?
Take care,
Mike the Plumber
Tidak ada komentar:
Posting Komentar