ACCESS FEED: Juni 2021

Minggu, 13 Juni 2021

Re: [MSAccessProfessionals] Crosstab report

I have an example with dynamic monthly columns which can be modified to any date interval at https://www.tek-tips.com/faqs.cfm?fid=5466

Duane

Sent from my mobile

On Jun 13, 2021, at 3:39 PM, Youssef <youssef2309@gmail.com> wrote:

Dear All,
I need to create a crosstab report for a students attendance so,
I have a row headings (student id - student name )
but for column heading it suppose to be weekly (date) and the also the query asks for start and end dates
so how number of columns is not known
how to build a report in this case
thanks in advance

Re: [MSAccessProfessionals] Crosstab report

When it comes to tricky reports no one can hold a candle to A.D. Tejpal. Take a look at his samples at:

http://www.rogersaccesslibrary.com/forum/samples-by-a-d-tejpal-alphabetical-index_topic405.html?SID=127-d11764zfd7838ez8e2399320023148

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Youssef
Sent: Sunday, June 13, 2021 1:39 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Crosstab report

Dear All,
I need to create a crosstab report for a students attendance so,
I have a row headings (student id - student name )
but for column heading it suppose to be weekly (date) and the also the query asks for start and end dates
so how number of columns is not known
how to build a report in this case
thanks in advance

[MSAccessProfessionals] Crosstab report

Dear All,
I need to create a crosstab report for a students attendance so,
I have a row headings (student id - student name )
but for column heading it suppose to be weekly (date) and the also the query asks for start and end dates
so how number of columns is not known
how to build a report in this case
thanks in advance

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Rabu, 09 Juni 2021

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

Selasa, 08 Juni 2021

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

AWA indeed had several limitations but was awesome in its design. It was actually a low code compiler to T-SQL. Version 3 or higher could have been perfect. We still use AWA all the time and use it from PowerAutomate/Flow SQL Exec Queries.

Rob

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of anzus101
Sent: woensdag 9 juni 2021 02:32
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

No necessarily. Access web apps still had several limitations with respect ms access. Open source will end up winning the battle on this one as you can produce similar ms access functionality with xampp, php and birt reports. It is not difficult, it will just take time to learn the technologies.

On 9/6/21 5:07 am, Giorgio Rovelli via groups.io wrote:

Combining multiple makes to achieve what Access Web Apps did without any conversion is plain cumbersome just because Microsoft were shortsighted enough to ditch AWA in favour of PowerApps that don't use VBA but rather low-code language.

06/08/2021 12:15 AM anzus101 <anzus101@gmail.com> wrote:

Guys,

You need a combination of a back end, preferably posture and a front end, Php generator. There are tools out here that convert ms access to any mainstream DB. It is not difficult.

On Tuesday, June 8, 2021, Giorgio Rovelli via groups.io <giorgio_rovelli=virgilio.it@groups.io> wrote:

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

On 9/6/21 5:07 am, Giorgio Rovelli via groups.io wrote:

Combining multiple makes to achieve what Access Web Apps did without any conversion is plain cumbersome just because Microsoft were shortsighted enough to ditch AWA in favour of PowerApps that don't use VBA but rather low-code language.

06/08/2021 12:15 AM anzus101 <anzus101@gmail.com> wrote:

Guys,
You need a combination of a back end, preferably posture and a front end, Php generator. There are tools out here that convert ms access to any mainstream DB. It is not difficult.

On Tuesday, June 8, 2021, Giorgio Rovelli via groups.io <giorgio_rovelli=virgilio.it@groups.io> wrote:

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

Combining multiple makes to achieve what Access Web Apps did without any conversion is plain cumbersome just because Microsoft were shortsighted enough to ditch AWA in favour of PowerApps that don't use VBA but rather low-code language.

06/08/2021 12:15 AM anzus101 <anzus101@gmail.com> wrote:

Guys,
You need a combination of a back end, preferably posture and a front end, Php generator. There are tools out here that convert ms access to any mainstream DB. It is not difficult.

On Tuesday, June 8, 2021, Giorgio Rovelli via groups.io <giorgio_rovelli=virgilio.it@groups.io> wrote:

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

Access Web Pages did just that.

Giorgio

On 06/08/2021 4:31 AM Lists <lists@pstrauss.net> wrote:

Converting the Back-End is relatively easy, even if you have to create the tables and relationships by hand. What is the real challenge is converting the forms, reports, and VBA to something that will run in a browser.Every time someone asks this question, the responders always seem to only talk about converting the Back-End. I don't think anyone knows of an answer to converting the Front-End; I certainly don't.

I would love to find that there is some tool, free or paid, that will convert the Front-End, even if only partially. It would be great to be able to build the program in MS Access, with the Back-End in some Client/Server Database on a web host, and then convert the Front-End to a bunch of web pages. Then the user could take his desktop app on the road. Who wouldn't love that? How much would a client pay for that? Not so easy without a tool.

A big part of the problem, as far as I know, is that MS Access is so much more powerful than a web page. Web pages are pretty powerful, and they seem to be getting better all the time, but browsers have a ways to go to catch up to Access forms. Emulating Access completely in JavaScript is probably not possible, but some JavaScript guru might think otherwise and I'd love to be wrong here. Perhaps Java would be the way to go, but I have no clue here as don't know anything about Java. I also have no idea how to get the kind of reports from a web site, as a PDF or as another web page, the we can dash off in Access in an hour or two.

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

Of course there's the html5 remote desktop client now. That works very nice with Access Desktop.

For the we implement a Post-API layer that communicates JSON back and fort, defines a ADO-object in code, fills it with JSON and assigns the ado object as recordsource to the form. The forms use API methods to update/create. We all build those with Power automate that connects to a SQL database (assembles Tsql Exec Queries that are passed in one roundtrip to SQL-server). SQL-Server is a very wealthy client environment to any API (odata to business Central, Navision etc but also to an Access Interop API that's enabled te perform vba in an Access of Excel backend).

To use SQL Server as odata client we have a C# clr deployed project that gives a stored procedure named WebApiCaller.

Rob

Van: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> Namens Lists
Verzonden: dinsdag 8 juni 2021 04:32
Aan: MSAccessProfessionals@groups.io
Onderwerp: Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

Converting the Back-End is relatively easy, even if you have to create the tables and relationships by hand. What is the real challenge is converting the forms, reports, and VBA to something that will run in a browser.Every time someone asks this question, the responders always seem to only talk about converting the Back-End. I don't think anyone knows of an answer to converting the Front-End; I certainly don't.

I would love to find that there is some tool, free or paid, that will convert the Front-End, even if only partially. It would be great to be able to build the program in MS Access, with the Back-End in some Client/Server Database on a web host, and then convert the Front-End to a bunch of web pages. Then the user could take his desktop app on the road. Who wouldn't love that? How much would a client pay for that? Not so easy without a tool.

A big part of the problem, as far as I know, is that MS Access is so much more powerful than a web page. Web pages are pretty powerful, and they seem to be getting better all the time, but browsers have a ways to go to catch up to Access forms. Emulating Access completely in JavaScript is probably not possible, but some JavaScript guru might think otherwise and I'd love to be wrong here. Perhaps Java would be the way to go, but I have no clue here as don't know anything about Java. I also have no idea how to get the kind of reports from a web site, as a PDF or as another web page, the we can dash off in Access in an hour or two.

Senin, 07 Juni 2021

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

You are correct. On my own primitive experience, I can say that Postgres has tons of stuff that can replace VBA on the back end. Alternatively Php maker 2020 does a lot of hard work for you, give it a try and you will see what I mean. It comes down to how complex your app is and what are you trying to do. I have been using Postgres and it is very good. But i am not an enterprise developer, i am the average joe that ditched excel for ms access.

On Tue, Jun 8, 2021 at 10:32 AM Lists <lists@pstrauss.net> wrote:

Converting the Back-End is relatively easy, even if you have to create the tables and relationships by hand. What is the real challenge is converting the forms, reports, and VBA to something that will run in a browser.Every time someone asks this question, the responders always seem to only talk about converting the Back-End. I don't think anyone knows of an answer to converting the Front-End; I certainly don't.

I would love to find that there is some tool, free or paid, that will convert the Front-End, even if only partially. It would be great to be able to build the program in MS Access, with the Back-End in some Client/Server Database on a web host, and then convert the Front-End to a bunch of web pages. Then the user could take his desktop app on the road. Who wouldn't love that? How much would a client pay for that? Not so easy without a tool.

A big part of the problem, as far as I know, is that MS Access is so much more powerful than a web page. Web pages are pretty powerful, and they seem to be getting better all the time, but browsers have a ways to go to catch up to Access forms. Emulating Access completely in JavaScript is probably not possible, but some JavaScript guru might think otherwise and I'd love to be wrong here. Perhaps Java would be the way to go, but I have no clue here as don't know anything about Java. I also have no idea how to get the kind of reports from a web site, as a PDF or as another web page, the we can dash off in Access in an hour or two.

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

I am at my pc now, here are the steps

1.- Convert to target d.b.

2.- Connect to PHP Maker 2020

Redesign forms.

You need to have xampp

On Tue, Jun 8, 2021 at 6:29 AM anzus101 via groups.io <anzus101=gmail.com@groups.io> wrote:

I meant postgres SQL. It is more robust than mysql

On Tuesday, June 8, 2021, Maurice A <anzus101@gmail.com> wrote:
Guys,
You need a combination of a back end, preferably posture and a front end, Php generator. There are tools out here that convert ms access to any mainstream DB. It is not difficult.

On Tuesday, June 8, 2021, Giorgio Rovelli via groups.io <giorgio_rovelli=virgilio.it@groups.io> wrote:

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

I meant postgres SQL. It is more robust than mysql

On Tuesday, June 8, 2021, Maurice A <anzus101@gmail.com> wrote:

Guys,
You need a combination of a back end, preferably posture and a front end, Php generator. There are tools out here that convert ms access to any mainstream DB. It is not difficult.

On Tuesday, June 8, 2021, Giorgio Rovelli via groups.io <giorgio_rovelli=virgilio.it@groups.io> wrote:

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

Guys,

You need a combination of a back end, preferably posture and a front end, Php generator. There are tools out here that convert ms access to any mainstream DB. It is not difficult.

On Tuesday, June 8, 2021, Giorgio Rovelli via groups.io <giorgio_rovelli=virgilio.it@groups.io> wrote:

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

MySQL isn't a Web-browser based application any more than Access is.

On 06/07/2021 9:48 PM Jerry <bearjercares@gmail.com> wrote:

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

Re: [MSAccessProfessionals] Convert MS Access application to Web-browser based application

I would love to know that myself. I did run across a document from Oracle on how to convert an MS Access database to MYSql, but it seemed a bit complex at the time.

Jerry in Michigan

-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116013): https://groups.io/g/MSAccessProfessionals/message/116013
Mute This Topic: https://groups.io/mt/83376149/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-

[MSAccessProfessionals] Convert MS Access application to Web-browser based application

Dear Experts,
I have developed several MS Access applications. But I want to convert it into web-browser based applcation. How it can be done? In older versions we had Access pages to achieve this. How it is done easily these days. Please guide. Thanks in advance.

Regards,
Kumar

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Selasa, 01 Juni 2021

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

ps, Mike, the way to link to Outlook might be a bit different...

1. Import group

2. New Data Source dropdown

3. From other Sources

4. Outlook folder

this will only work for a local Outlook folder, not a cloudy one ;)

kind regards,
crystal

On 6/1/2021 2:17 PM, crystal (strive4peace) via groups.io wrote:

hi Mike,

great. To test what you get with linking to a mailbox:

1. make a LOCAL folder on Outlook and put some messages in there.

in Access, to link local Outlook mailbox:

External Data ribbon
Import & Link Group: More
Outlook folder
-- chose Link and then pick folder and mailbox you want

Access should be able to send your text messages too! You'll need to know the carrier for each of the phones you want to text so the proper email address can be constructed. Have a look at this wiki article for more info:

https://en.wikipedia.org/wiki/SMS_gateway

and here is a pretty good list of domains to use for different carriers:

https://avtech.com/articles/138/list-of-email-to-sms-addresses/

kind regards,
crystal

On 6/1/2021 12:04 PM, michael simpson via groups.io wrote:

Crystal -

This is exactly what I want to do... "Access can link to, parse message, and get data"

At the moment I am retyping the write up on the work orders, which is annoying to say the least... On sending work orders to the field I am currently using text messages.. which is then copied to a paper work order, and then retyped by myself when the paperwork is submitted...

A CSV file or something that can be up and down loaded for individual work orders, do not need access to the database in the field

Take care,

Mike the Plumber

Sac City Plumbing

Phone: (916) 837-2211

On Tuesday, June 1, 2021, 09:20:35 AM PDT, crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

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

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

hi Mike,

great. To test what you get with linking to a mailbox:

1. make a LOCAL folder on Outlook and put some messages in there.

in Access, to link local Outlook mailbox:

External Data ribbon
Import & Link Group: More
Outlook folder
-- chose Link and then pick folder and mailbox you want

Access should be able to send your text messages too! You'll need to know the carrier for each of the phones you want to text so the proper email address can be constructed. Have a look at this wiki article for more info:

https://en.wikipedia.org/wiki/SMS_gateway

and here is a pretty good list of domains to use for different carriers:

https://avtech.com/articles/138/list-of-email-to-sms-addresses/

kind regards,
crystal

On 6/1/2021 12:04 PM, michael simpson via groups.io wrote:

Crystal -

This is exactly what I want to do... "Access can link to, parse message, and get data"

At the moment I am retyping the write up on the work orders, which is annoying to say the least... On sending work orders to the field I am currently using text messages.. which is then copied to a paper work order, and then retyped by myself when the paperwork is submitted...

A CSV file or something that can be up and down loaded for individual work orders, do not need access to the database in the field

Take care,

Mike the Plumber

Sac City Plumbing

Phone: (916) 837-2211

On Tuesday, June 1, 2021, 09:20:35 AM PDT, crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

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

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

Crystal -

This is exactly what I want to do... "Access can link to, parse message, and get data"

At the moment I am retyping the write up on the work orders, which is annoying to say the least... On sending work orders to the field I am currently using text messages.. which is then copied to a paper work order, and then retyped by myself when the paperwork is submitted...

A CSV file or something that can be up and down loaded for individual work orders, do not need access to the database in the field

Take care,

Mike the Plumber

Sac City Plumbing

Phone: (916) 837-2211

On Tuesday, June 1, 2021, 09:20:35 AM PDT, crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

hi Mike,

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

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

hi Mike,

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