Access Locks Up
Todd Heiks
I see posts about people experiencing the issue but no solutions, other then
upgrade.
My access database freezes for 6 - 9 minutes about two times a week. About
two times a day it freezes for 1-2 minutes. The long freezes happen during
a simple query that usually executes in less then a second.
I use an Access 97 mdb with 1 user/application. The application is a VB app
that runs continuously. The app holds the connection to the db open all the
time. The app is restarted about every two weeks. The app handles requests
from clients at the rate of 2000 - 4000 per 10 hour period. The app has
been running for about 10 years with no issues. The request volume is about
half of what it was two years ago, thanks to the economy, but I have not had
a problem until now. The db only handles select queries only. Data is
appended manually about once per year.
Yes, I would love to convert to SQL.
I would appreciate any insight that you could share.
I have cleaned, packed, and recreated to no avail.
Regards,
Todd
Danny J. Lesandrini
Great job on outlining your problem, that really helps.
My first thought was inspired by a problem I have had recently: Add Ins.
Check out your Add In list and remove anything that's not needed. This
may include uninstalling the Visual Soruce Safe stuff, if that had been
installed. My app was getting stuck with more regularity until I cleaned
out the AddIns.
Another couple things that may seem odd, but are worth a try are these:
1) Delete all the cookies and run the Disk Cleanup system tool
2) Remove any printers from the list that you don't need.
I can't explain why these help ... at least I can't explain it well, but when
there exists a performance issue I can't otherwise explain, I do these
things. For example, the printer issue applies to printers that no longer
exist on the network. If you keep the reference, Windows does this
behind-the-scenes polling thing, looking for it. Someone else put me onto
the cookies issue. I scoffed, but did it anyhow. It worked for me.
--
Danny J. Lesandrini
dlesa...@hotmail.com
www.amazecreations.com
"Todd Heiks" <Todd.Heiks_AT_NoSpam_GreatLakesWindow.com> wrote ...
Chris O'C via AccessMonster.com
Chris
--
Message posted via http://www.accessmonster.com
Todd Heiks
What are the issues with AVG?
"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:9289adeb150fb@uwe...
Todd Heiks
"Danny J. Lesandrini" <dlesa...@hotmail.com> wrote in message
news:O0t1n$BnJH...@TK2MSFTNGP06.phx.gbl...
Chris O'C via AccessMonster.com
If Access is using the same ports that got hijacked, you have to wait for the
virus scanner to check the network packets for viruses. Slows down apps.
Enough to make them freeze up.
Chris
Todd Heiks wrote:
>This is a possibility. The users have rights to their boxes.
>What are the issues with AVG?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200903/1
Todd Heiks
Any user with access to the network share could point their AV software at
the share and scan it.
So how would I go about polling the share to see who is accessing it?
Thanks,
Todd
"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:9289adeb150fb@uwe...
Chris O'C via AccessMonster.com
Chris
Todd Heiks wrote:
>So how would I go about polling the share to see who is accessing it?
--
Todd Heiks
When I started having issues, I spun up a new VM just to host the app and
another one to host the db.
That's what made me think that it had something to do with the db.
People still run MS Access? Right?
Todd
"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:928a41f88768e@uwe...
Chris O'C via AccessMonster.com
Millions of people are running Access. Maybe tens of millions. Maybe more.
It's the most popular db.
Chris
Todd Heiks wrote:
>No AVG on the servers.
>
>When I started having issues, I spun up a new VM just to host the app and
>another one to host the db.
>That's what made me think that it had something to do with the db.
>
>People still run MS Access? Right?
--
David W. Fenton
> Are you or anybody on your network running AVG ver 8 anti virus?
Everybody turns off MDB scanning in any AV software they are
running, right?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
David W. Fenton
> An update to Ver 8 reroutes some network traffic through the virus
> scanner. If Access is using the same ports that got hijacked, you
> have to wait for the virus scanner to check the network packets
> for viruses. Slows down apps. Enough to make them freeze up.
Even if you turn off MDB scanning?
I use AVG and many of my clients do (we all finally got completely
sick of Symantec's garbage and McAfee's crap), and I have them
uniformly configured to *not* scan MDBs. Is the problem you're
outlining independent of that?
And does it only matter if you're pulling the data across the wire?
That might explain why none of my clients and I have encountered the
problem, as none of my clients using AVG run their database with a
server.
aaron...@gmail.com
Nobody in their right mind uses Jet for anything, I mean are you
retarded?
-Aaron
On Mar 3, 8:38 am, "Todd Heiks"
Chris O'C via AccessMonster.com
on the network. I'll explain more in depth in a reply to your other post.
Chris
David W. Fenton wrote:
>> Are you or anybody on your network running AVG ver 8 anti virus?
>
>Everybody turns off MDB scanning in any AV software they are
>running, right?
--
Chris O'C via AccessMonster.com
surf shield so it scans the data packets for viruses. Doesn't matter if you
already had it set not to scan mdb files. If your Access app is using those
same ports that get rerouted to surf shield to check if they're safe, your
app will freeze while surf shield scans the data and could lock up.
I don't think it matters if you're only pulling data. I think it's specific
ports that are affected and if Access uses those ports, it's going to freeze
while surf shield scans.
Chris
David W. Fenton wrote:
>> An update to Ver 8 reroutes some network traffic through the virus
>> scanner. If Access is using the same ports that got hijacked, you
>> have to wait for the virus scanner to check the network packets
>> for viruses. Slows down apps. Enough to make them freeze up.
>
>Even if you turn off MDB scanning?
>
>I use AVG and many of my clients do (we all finally got completely
>sick of Symantec's garbage and McAfee's crap), and I have them
>uniformly configured to *not* scan MDBs. Is the problem you're
>outlining independent of that?
>
>And does it only matter if you're pulling the data across the wire?
>That might explain why none of my clients and I have encountered the
>problem, as none of my clients using AVG run their database with a
>server.
>
--
Todd Heiks
Thats what I thought you would say, but I'm not sure that qualifies as
insight.
-Todd
<aaron...@gmail.com> wrote in message
news:abac0f6d-6df1-4676...@d2g2000pra.googlegroups.com...
aaron...@gmail.com
I don't see MS Access anywhere at www.olapreport.com/market.htm
-Aaron
On Mar 3, 11:17 am, "Chris O'C via AccessMonster.com" <u29189@uwe>
wrote:
aaron...@gmail.com
it runs faster, development is _EASIER_ and you get better tools.
And your end users will love the stability / performance.
And it's _FREE_.
-Aaron
On Mar 4, 5:22 am, "Todd Heiks"
<Todd.Heiks_AT_NoSpam_GreatLakesWindow.com> wrote:
> Aaron-
>
> Thats what I thought you would say, but I'm not sure that qualifies as
> insight.
>
> -Todd
>
> <aaron.ke...@gmail.com> wrote in message
Todd Heiks
Are you like the Don Rickles of newsgroups?
I know SQL is the way to go. Everyone knows that. Even the mentally
challenged that you previously referred to know.
Unfortunately, SQL is not an option for this client.
You seem to be all over the newsgroups. Can you lend some of your time /
intellect to the solution of the problem?
Regards,
Todd
<aaron...@gmail.com> wrote in message
news:c3db414c-cbb0-4cec...@y33g2000prg.googlegroups.com...
aaron...@gmail.com
lose the premises and the assumptions.. and no-- everyone in this
group clings to an obsolete database engine-- because dipshits like
Tony Toews try to scare people into sticking with the sinking ship...
(JET).
-Aaron
On Mar 4, 8:07 am, "Todd Heiks"
<Todd.Heiks_AT_NoSpam_GreatLakesWindow.com> wrote:
> Dude-
>
> Are you like the Don Rickles of newsgroups?
> I know SQL is the way to go. Everyone knows that. Even the mentally
> challenged that you previously referred to know.
> Unfortunately, SQL is not an option for this client.
> You seem to be all over the newsgroups. Can you lend some of your time /
> intellect to the solution of the problem?
>
> Regards,
> Todd
>
> <aaron.ke...@gmail.com> wrote in message
aaron...@gmail.com
MOVE TO SQL
Jet corrupts, it crashes-- it's not SMP aware, and it doesn't work in
X64
-Aaron
On Mar 4, 8:07 am, "Todd Heiks"
<Todd.Heiks_AT_NoSpam_GreatLakesWindow.com> wrote:
> Dude-
>
> Are you like the Don Rickles of newsgroups?
> I know SQL is the way to go. Everyone knows that. Even the mentally
> challenged that you previously referred to know.
> Unfortunately, SQL is not an option for this client.
> You seem to be all over the newsgroups. Can you lend some of your time /
> intellect to the solution of the problem?
>
> Regards,
> Todd
>
> <aaron.ke...@gmail.com> wrote in message
BruceM
"Todd Heiks" <Todd.Heiks_AT_NoSpam_GreatLakesWindow.com> wrote in message
news:%23nwdYOO...@TK2MSFTNGP06.phx.gbl...
aaron...@gmail.com
Oh, it's BWUCE!!!
Why don't you learn to prevent _ALL_ jet corruption, until then STFU
script-kiddie
-Aaron
On Mar 4, 12:19 pm, "BruceM" <bam...@yawhodotcalm.not> wrote:
> Aaron doesn't offer specific details, just rants.
>
> "Todd Heiks" <Todd.Heiks_AT_NoSpam_GreatLakesWindow.com> wrote in message
>
> news:%23nwdYOO...@TK2MSFTNGP06.phx.gbl...
>
> > Dude-
>
> > Are you like the Don Rickles of newsgroups?
> > I know SQL is the way to go. Everyone knows that. Even the mentally
> > challenged that you previously referred to know.
> > Unfortunately, SQL is not an option for this client.
> > You seem to be all over the newsgroups. Can you lend some of your time /
> > intellect to the solution of the problem?
>
> > Regards,
> > Todd
>
> > <aaron.ke...@gmail.com> wrote in message
David W. Fenton
> An update about 4 weeks ago on AVG 8 reroutes some network traffic
> through surf shield so it scans the data packets for viruses.
> Doesn't matter if you already had it set not to scan mdb files.
> If your Access app is using those same ports that get rerouted to
> surf shield to check if they're safe, your app will freeze while
> surf shield scans the data and could lock up.
Is there any documentation anywhere about which ports are involved?
And is it only happening when you're retrieving an MDB across a
network connection?
> I don't think it matters if you're only pulling data. I think
> it's specific ports that are affected and if Access uses those
> ports, it's going to freeze while surf shield scans.
What if you turn off these settings:
- Scan for Tracking Cookies
- Scan Potentially Unwanted Programs and Spyware
If you're not using IE as your web browser and use some other
product (like Spybot Search and Destroy or AdAware) to provide
spyware protection, you won't in any significant danger of
infection.
It is annoying to me that I can't just turn off the Spyware
"protection," as it's not something I have any need for at all.
aaron...@gmail.com
You also need a firewall-- or router--
A lot of people connect directly to the internet, and because MS is
too busy working on the 'next great version of windows' they never
seem to plug holes in their existing products.
I used to do intrusion detection (datamarts) at Microsoft.. Even in
Redmond-- we couldn't crack down on malware-- AT ALL-- until Windows
XP SP2 came out.
This turned the firewall on by default, right?
-Aaron
PS - 'not using IE'-- uh.. none of the other browsers have -HALF- of
the functionality of IE.. so I really don't understand what you're
talking about in 'other browsers'
On Mar 4, 3:53 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> "Chris O'C via AccessMonster.com" <u29189@uwe> wrote innews:929014f85aa69@uwe:
Chris O'C via AccessMonster.com
installed to test with. 2 friends had it happen to them and they emailed me
warnings about slow apps and networks and this link with info
http://freeforum.avg.com/read.php?14,171466
Only ports 80 and 8080 are named in that post, but he indicates there's more
affected.
Chris
David W. Fenton wrote:
>> An update about 4 weeks ago on AVG 8 reroutes some network traffic
>> through surf shield so it scans the data packets for viruses.
>> Doesn't matter if you already had it set not to scan mdb files.
>> If your Access app is using those same ports that get rerouted to
>> surf shield to check if they're safe, your app will freeze while
>> surf shield scans the data and could lock up.
>
>Is there any documentation anywhere about which ports are involved?
>And is it only happening when you're retrieving an MDB across a
>network connection?
>
>> I don't think it matters if you're only pulling data. I think
>> it's specific ports that are affected and if Access uses those
>> ports, it's going to freeze while surf shield scans.
>
>What if you turn off these settings:
>
>- Scan for Tracking Cookies
>- Scan Potentially Unwanted Programs and Spyware
>
>If you're not using IE as your web browser and use some other
>product (like Spybot Search and Destroy or AdAware) to provide
>spyware protection, you won't in any significant danger of
>infection.
>
>It is annoying to me that I can't just turn off the Spyware
>"protection," as it's not something I have any need for at all.
>
--
Michel Walsh
you say Access does not work in "X64"?
Vanderghast, Access MVP
<aaron...@gmail.com> wrote in message
news:3d2da328-a9f5-4900...@p6g2000pre.googlegroups.com...
vanzandt
popularity. Not all databases can be configured to fully support OLAP. OLAP
is online analytical processing, which uses multidimensional data models.
Multibillion dollar businesses and governments use OLAP databases for their
data warehousing and business intelligence because they're the only ones who
can afford it. That's a pretty small segment when compared to the whole
database market.
The database products which can fully support OLAP and are listed on
that page will set you back thousands of dollars up to over $100,000. Access
is a relational database that costs over $100. Alot more affordable and
without alot of the features the big databases provide that cost so much.
OLAP databases need to be designed and operated by expensive, trained users
vs anyone who can use a Windows PC can build and use an Access database.
Access isn't designed to support OLAP and Access users don't need it
to. You can't expect to see it or any other non-OLAP database on that list.
Access supports small relational databases for a small group of users on a
LAN and does it very well at small cost. I daresay that's why it's so common
in so many small businesses, schools and homes all over the world.
<aaron...@gmail.com> wrote in message
news:7f472867-2f68-43fd...@p36g2000prp.googlegroups.com...
aaron...@gmail.com
you're a mother fucking idiot.
SQL Server Analysis Services (Standard) starts at about $1200.
So sorry that you're mis-informed.
and Olap is just one piece of the equation..
RBDMS --> SQL Server beats Jet
SSIS --> SQL Server beats Jet
SSRS --> SQL Server beats Jet
SSAS --> I've built hundreds and hundreds of cubes.. and there isn't
anything in the world that Jet can do that can even compare
On Mar 5, 8:00 am, "vanzandt" <vanza...@nospam.net> wrote:
> Don't use the list on olapreport.com as your yardstick for database
> popularity. Not all databases can be configured to fully support OLAP. OLAP
> is online analytical processing, which uses multidimensional data models.
> Multibillion dollar businesses and governments use OLAP databases for their
> data warehousing and business intelligence because they're the only ones who
> can afford it. That's a pretty small segment when compared to the whole
> database market.
>
> The database products which can fully support OLAP and are listed on
> that page will set you back thousands of dollars up to over $100,000. Access
> is a relational database that costs over $100. Alot more affordable and
> without alot of the features the big databases provide that cost so much.
> OLAP databases need to be designed and operated by expensive, trained users
> vs anyone who can use a Windows PC can build and use an Access database.
>
> Access isn't designed to support OLAP and Access users don't need it
> to. You can't expect to see it or any other non-OLAP database on that list.
> Access supports small relational databases for a small group of users on a
> LAN and does it very well at small cost. I daresay that's why it's so common
> in so many small businesses, schools and homes all over the world.
>
> <aaron.ke...@gmail.com> wrote in message
vanzandt
that's all you need to support a typical company's Access databases. SQL
Server Analysis Services needs hardware and software (and usually
networking) costing many thousands of dollars to support a company's OLAP
requirements, in addition to the $1200 starting price. Plus expensive,
skilled employees to design, use and support OLAP databases.
Access is a desktop database which doesn't require expensive computer
equipment or highly trained employees to design or run it. Just about anyone
can install and run Access. The same can't be said about SQL Server's OLAP
support. But most companies don't need that anyway. They just need an
affordably priced, multiuser relational database management system that can
reliably handle up to 1 to 2 GB of data. Access is the answer to that need
far more often than not.
<aaron...@gmail.com> wrote in message
news:67077ee8-0bc7-4a74...@y33g2000prg.googlegroups.com...
aaron...@gmail.com
for -cheap- on ebay.
I technically prefer SSAS 2000 to any other flavor-- for dev of simple
cubes
-aaron
On Mar 13, 4:03 am, "vanzandt" <vanza...@nospam.net> wrote:
> Access and the PC, monitor and OS to run it start at about $650. And
> that's all you need to support a typical company's Access databases. SQL
> Server Analysis Services needs hardware and software (and usually
> networking) costing many thousands of dollars to support a company's OLAP
> requirements, in addition to the $1200 starting price. Plus expensive,
> skilled employees to design, use and support OLAP databases.
>
> Access is a desktop database which doesn't require expensive computer
> equipment or highly trained employees to design or run it. Just about anyone
> can install and run Access. The same can't be said about SQL Server's OLAP
> support. But most companies don't need that anyway. They just need an
> affordably priced, multiuser relational database management system that can
> reliably handle up to 1 to 2 GB of data. Access is the answer to that need
> far more often than not.
>
aaron...@gmail.com
uh-- do you mean the excel dorks that litter the IT world?
They love pivotTables more than most kids in harlem love crack
cocaine.
Access without SQL is fucking pointless... It's a platform that has
been obsolete for a decade.. It has no migration path..
Putting SQL Server on a desktop-- and using MSDE / SQL Express-- is
the same expense as doing anything similiar with Jet.
Except SQL supports SMP (and Jet doesn't) and SQL also utilizes this
thing called 'MEMORY'-- which means, the simple math is that SQL
Server can read stuff out of memory faster than jet can read it from
disk.
At the same price-- there is no comparison between Jet and SQL Server
performance
or stability
or ease of administration
or scalability
Jet doesn't win any argument, and it hasn't in a decade
It's not easier for development either (if it is, that just means
you're too much of a retard to know what SSMS / QA / EM is)
-Aaron
On Mar 13, 4:03 am, "vanzandt" <vanza...@nospam.net> wrote:
> Access and the PC, monitor and OS to run it start at about $650. And
> that's all you need to support a typical company's Access databases. SQL
> Server Analysis Services needs hardware and software (and usually
> networking) costing many thousands of dollars to support a company's OLAP
> requirements, in addition to the $1200 starting price. Plus expensive,
> skilled employees to design, use and support OLAP databases.
>
> Access is a desktop database which doesn't require expensive computer
> equipment or highly trained employees to design or run it. Just about anyone
> can install and run Access. The same can't be said about SQL Server's OLAP
> support. But most companies don't need that anyway. They just need an
> affordably priced, multiuser relational database management system that can
> reliably handle up to 1 to 2 GB of data. Access is the answer to that need
> far more often than not.
>
aaron...@gmail.com
affordably priced, multiuser relational database management system
that can
other databases on the same server). SQL Server Express is the answer
to that need
far more often than not.
On Mar 13, 4:03 am, "vanzandt" <vanza...@nospam.net> wrote:
> Access and the PC, monitor and OS to run it start at about $650. And
> that's all you need to support a typical company's Access databases. SQL
> Server Analysis Services needs hardware and software (and usually
> networking) costing many thousands of dollars to support a company's OLAP
> requirements, in addition to the $1200 starting price. Plus expensive,
> skilled employees to design, use and support OLAP databases.
>
> Access is a desktop database which doesn't require expensive computer
> equipment or highly trained employees to design or run it. Just about anyone
> can install and run Access. The same can't be said about SQL Server's OLAP
> support. But most companies don't need that anyway. They just need an
> affordably priced, multiuser relational database management system that can
> reliably handle up to 1 to 2 GB of data. Access is the answer to that need
> far more often than not.
>