Dec 07 2018 02:11 PM
Hi everyone. We are a company who currently uses Access for a lot of our reports and setting up and tracking jobs. All of our office computers are setup on a central server (we are not cloud based). We are looking into the possibility of adding tablets to our crews so they can do reports onsite (eliminating paper and double work). I know Access is only on desktops/laptop and we are looking into using Surface Pros, from my understanding Access is on the SP.
Would we have to create a web-based app for them to access the database while offsite or will the full database be available while offsite and when they return to the office, they will have to upload it to the server.
I apologize if this is unclear, I am not an IT person and am just starting to really learn my way around access. Any insight will be much appreciated.
Dec 09 2018 12:39 PM
Dec 12 2018 12:35 AM
Does that answer your questions?
You can read more in my post about RemoteApp vs. VPN and alternatives for mobile / cloud / Mac / web / multi-user use of Microsoft Acce.... I hope those tips help.
Sincerely,
Dan
________________________________________________________________________
Dan Moorehead
Founder, PowerAccess
👉 Subscribe to Empower Microsoft Access & Excel with:
● PowerAccess (All-in-One Toolset | Framework for Access)
● CrushErrors.com (AI for Finance | Fuzzy Match | Dedupe | Excel)
● PowerVBA (COM-free C# / VB.NET for Access / Excel / Office)
● PowerExcel (SQL | Dynamic Array Functions for Excel) ● PowerSQL (Power Query for Access)
● PowerAccess2SQL (Access to SQL Server – AI-automated | optimized)
Dec 12 2018 06:09 AM
Thank you, yes your response did provide answers. The next step for us is to decide which route we want to go for the company. Access and in essence 365 is a VERY powerful tool and I feel we are only using a very small percentage of their capabilities! I also looked into poweraccess and it was very intriguing (I saw you are a developer in in it, and appreciate the honest answers and not just a sales pitch).
As far as developing with poweraccess how would that work? I am guessing it would all be off site, we say what we want and go from there? Potentially we will be looking into using access for all of our accounting/payroll system to link with our already established database. A system like this would be beyond what we would be capable of doing in house.
Like I said before we are a small company starting to look into taking our next step forward to maximize the tech. we have available....