Re: [MSAccessProfessionals] [MSAccessProfessionals] I use MS Access in the office, how should I send work orders out to the field.....

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

On 5/31/2021 11:20 PM, Bill Mosca wrote:

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