We help IT Professionals succeed at work.
Get Started

I need Access/Azure advice

180 Views
Last Modified: 2016-07-27
Hello All

I was hoping to get some advice.  As many of you know I have an Access database which I have split with the backend going onto Azure and everyone getting a front end on their computer.  We got a third party to convert all the tables into Azure SQL and all the queries into stored procedures.  They also did a bunch of other things that are way above my pay grade.  I am ok with Access VBA but not with SQL and stored procedures.

I took my original version and put the tables only onto another Azure server while leaving everything else in Access (so all my queries are in the Access frontend).  It runs painfully slow.  Correct me if I am wrong but even though none of the forms are directly attached to any table I think all the data has to come over before the queries restrict things (which would explain the slowness I think)?  The users want to be able to run the Access front end from any computer which is why I figured I had to put the backend on Azure.

Here are my questions:

1. Is it possible to have just the tables up on Azure with the frontend (including the queries) on each person's computer but get it to run faster?

2. Is there another way to provide access to the program from any computer but maybe use a different connection method?  For example could I put everyone's front end on the Azure server along with the backend data and give them some sort of remote access?  I figure I could beef up the Azure server to handle the extra traffic?

So it comes down to the fact that I need to speed the program up, keep the program available to users from any computer, all without using stored procedures.

Thank you all!
Comment
Watch Question
David Johnson, CDThe More I know, the more I don't know
CERTIFIED EXPERT
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 6 Answers and 11 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE