Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-15-2014, 06:30 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 SQL Issue?

I was included in a project where an outside vendor was brought in to set up a SQL Server backend for an Access database I developed. Since it has been running, all my Access databases are really slow, with some of them not even wanting to close. I have developed several other Access databases with Access back-ends on a network drive. None of the other users are having this issue.

Is there something I can do to stop this from happening?

Thank you.

Learn2010 is offline   Reply With Quote
Old 07-15-2014, 07:10 AM   #2
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,072
Thanks: 80
Thanked 2,004 Times in 1,952 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: SQL Issue?

How was this project organized? Who was project lead? Who set up the contract?Who was responsible for testing and acceptance? Seems there is more involved than the small piece you have mentioned.
Somebody has to accept the system/database or something and it should have met the "acceptance criteria" before sign off. At least that's how we did things when third party consultant/programmer/designer was involved.

What exactly do you want to STOP happening?
__________________

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.

Last edited by jdraw; 07-15-2014 at 07:11 AM. Reason: spelling
jdraw is offline   Reply With Quote
Old 07-15-2014, 07:32 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: SQL Issue?

I understand all that. The problem seems to be that somehow SQL is holding my resources in some manner and I need it to let go.

Learn2010 is offline   Reply With Quote
Old 07-15-2014, 08:47 AM   #4
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: SQL Issue?

In answer to your questions, read this.

How was this project organized? By people that had no part in the outcome.

Who was project lead? A guy that had no part in the outcome or set up and testing.

Who set up the contract? A Supervisor that had no idea what was going on, but had a deadline to meet, which became my deadline.

Who was responsible for testing and acceptance? Two people that had no part in the outcome, myself, and two users that never got to use it. After it was supposedly finished, it was handed over to me, and I was supposed to manage it.

Seems there is more involved than the small piece you have mentioned. Yes there is.

Now, do you know why SQL would lock up my programs or don't you?

Thank you.
Learn2010 is offline   Reply With Quote
Old 07-16-2014, 05:51 AM   #5
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,072
Thanks: 80
Thanked 2,004 Times in 1,952 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: SQL Issue?

I don't know why your database is acting as it is, but here is a link to performance tips that you can check.

Do you know if there is appropriate indexing on fields? Sequential reads can be a nightmare in any dbms.
Do you have test data to identify any specific function/procedure...?
Have you tied putting some comments/messages re "in this procedure at time..." and done any analysis?
Have you had any network or sql server people check any of their monitoring tools?
Did this particular database ever run faster than it is currently? If so, what changed?
Has anyone talked to the third party developers for ideas/suggestions?

This may be relevant, you can see what others have experienced/done.
Good luck.
__________________

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.

Last edited by jdraw; 07-16-2014 at 02:08 PM.
jdraw is offline   Reply With Quote
Old 07-16-2014, 06:47 AM   #6
pr2-eugin
Super Moderator
 
pr2-eugin's Avatar
 
Join Date: Nov 2011
Location: Bournemouth, UK
Posts: 8,498
Thanks: 68
Thanked 2,066 Times in 2,014 Posts
pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about pr2-eugin has a spectacular aura about
Re: SQL Issue?

The response by Albert Kallal, seems to be quiet informative : http://social.msdn.microsoft.com/For...orum=accessdev

__________________
Regards,
Paul Eugin

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
!
!
Windows 7 Professional, MS Access 2010
---------------------------------------------------------------------------------------------------------------------
If the above post has helped you, please click the scales
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
or click the 'Thumbs up'. Cheers.

---------------------------------------------------------------------------------------------------------------------



pr2-eugin 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
Table Issue & Query Issue Jgr4ng3 Tables 1 03-18-2013 09:19 PM
[SOLVED] IF/Then issue LewisWA02 Modules & VBA 9 05-31-2012 09:59 PM
Can anyone help me with this tab issue. jaluna25 Word 2 04-14-2012 03:55 AM
New Issue - Need some Help CalvinToo Forms 48 08-21-2008 02:38 PM
First DB issue MrBLT Tables 4 11-27-2003 06:44 PM




All times are GMT -8. The time now is 09:06 PM.


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