Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-26-2019, 03:36 AM   #1
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 404
Thanks: 92
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Thumbs up Optimization

The new IT group is attempting to move all Access DBs into one area on the shared drive. Since the process started several months ago, there has been a noticeable continuous slowing of one of my DBs. It is linked to a SQL Server. I have no permissions to do anything to the SQL Server. I have optimized Access as much as I can. Is there something I can do to speed up this Access DB?

Thank you.

Learn2010 is offline   Reply With Quote
Old 06-26-2019, 03:54 AM   #2
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,662
Thanks: 99
Thanked 1,501 Times in 1,416 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Optimization

Can be many different things. Missing indexes are likely when queries start to slow down as the data grows. If you have views on the server they can benefit from just being forced to rebuild their statistics and plans when the data grows.

It is very difficult to make the most of the server without even being able to connect to it. See if your IT team will give you a login so you can at least look at the indexes on tables. You have to start worming your way in and you can't really break anything just looking.

I'm very lucky to be in a small shop where I am an SQL Server Admin too. It makes a big difference when you can actually build stuff on the server and use its tools to analyse and optimise queries.
Galaxiom is offline   Reply With Quote
The Following User Says Thank You to Galaxiom For This Useful Post:
Learn2010 (06-26-2019)
Old 06-26-2019, 04:30 AM   #3
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 404
Thanks: 92
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Re: Optimization

There is no way. Access is frowned upon here and if they could get rid of it they would. Just recently they heard that Microsoft was getting rid of Access and it was sheer jubilation. I let them know about the SharePoint version that was being done away with and that the actual Microsoft Access software was here to stay. Some were dumbfounded.

Anything I do has to be on this end and through the Access software or if there is something I can do to the links then that would be all.

Thank you.

Learn2010 is offline   Reply With Quote
Old 06-26-2019, 04:30 AM   #4
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,435
Thanks: 165
Thanked 1,738 Times in 1,707 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Optimization

If you are using a shared front end from a network location that will be slow.
And probably lead to longer term issues, such as corruption.

Each user should have the FE Access db locally on their PC.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 06-26-2019, 04:54 AM   #5
Learn2010
Newly Registered User
 
Join Date: Sep 2010
Posts: 404
Thanks: 92
Thanked 0 Times in 0 Posts
Learn2010 is on a distinguished road
Re: Optimization

There are only 3 users. Each has their own front-end and it resides on a shared drive as directed by the managers. I put front-end on my C drive and it does the same thing. I have compacted and repaired it and I use a module to turn off the subdatasheets.
Learn2010 is offline   Reply With Quote
Old 06-26-2019, 07:07 AM   #6
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,435
Thanks: 165
Thanked 1,738 Times in 1,707 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Optimization

What type of network are you on Wired or Wireless?

The shared drive is nonsense, it's a FE with no data in it, why does it need to be on a shared drive? They clearly have no or incorrect knowledge about how Access works.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Learn2010 (06-26-2019)
Old 06-26-2019, 07:47 AM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,923
Thanks: 57
Thanked 1,296 Times in 1,277 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Optimization

Hi. You probably have seen this already but here it is anyway. Good luck!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 06-26-2019, 02:22 PM   #8
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,575
Thanks: 92
Thanked 1,682 Times in 1,560 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Optimization

You may show this to your managers if you wish.

Before retirement, I worked at the Navy Enterprise Data Center New Orleans, one of a small number of Navy hosting sites. As we grew, we had 1200-1500 servers spread over 60-80 projects including some with either "Sensitive but Unclassified" (SBU) or Secret requirements. (It was not a Top Secret site, though.) ALL of our people had to have Secret clearances to even work on the in-house network, me included.

One of our biggest projects, data-wise, was from BUMED (U.S. Navy Bureau of Medicine), which used an Access Front End and an SQL Server back end. This project had to conform to both Privacy Act and HIPAA requirements - which it did. The FE files were on individual user machines in that environment. I estimate a user base of between 40 and 50 medical records clerks plus a couple of supervisors. Sorry, cannot legally tell you anything about the number of people or incidents that database actually tracked.

We were able to demonstrate that NO repeat NO sensitive data was ever stored in the FE files and that the ability of the user to print a report was a bigger risk than having an FE file on a workstation. The report ability was going to be a reality regardless of where the FE files were located.

It is an example of false security to force deployment of Access FE files in a way that risks damage to the back-end database. Stated another way, it is a violation of the principle of Operational Security to knowingly place a program in an at-risk environment if the risk includes damaging the data repository. The U.S. Navy saw fit to use a distributed Access front-end on sensitive personnel records subject to strict security requirements.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Optimization khurram7x Queries 4 04-22-2016 11:23 AM
Optimization Algorithm ions Modules & VBA 12 07-26-2015 05:22 PM
PDF optimization? hkimpact Modules & VBA 3 01-17-2013 03:04 PM
Data Optimization AngeloWolfe Theory and practice of database design 1 07-29-2011 01:21 PM
Optimization Question sondriven Modules & VBA 1 09-10-2002 06:54 AM




All times are GMT -8. The time now is 08:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World