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

Morning,

You would have to make Office Interop operational and then have a gateway from Office365 to your office premises. In your office you run SQL-server with a clr C# API caller (like postman). In powerautomate/flow you assemble simple t-sql scripts that are being assembles by calls from PowerApps. Your SQL-database functions (can also be SQL-Server Exrpess I think) is used as a WebAPI client to an Access Interop API service. When you have that running you will have Access integrated for decades to come. You can invoke vba functions from PowerApps. There are some tricks to improve scalability dozens or even hundreds  of concurrent users.

Rob

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: dinsdag 1 juni 2021 18:19
To: MSAccessProfessionals@groups.io
Subject: 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