Access 203 has become sluggish since this morning.

B

Bk

I have been developing an order entry system for the last few months and
Access has worked extremely well. I am keeping things very simple.

I was working on my data base this morning and everything was fine. I came
back this afternoon and now Access takes several minutes to open tables etc
where it was instantaneous up to this morning.

I repair/compacted the data base. It worked eventually but took a very long
time to process. I tried a backup copy of the data base and got the same
results.

I have scanned for viruses and seem to be clean.

I am desparate for any ideas ... Bk.
 
6

'69 Camaro

Hi.
I have scanned for viruses and seem to be clean.
Click to expand...

Antivirus applications that continuously scan the hard drive or network can
cause Access to become sluggish if the MDB/MDE/MDA files aren't left off of
the list of files to scan. Also, if this is a networked database file,
other processes may be using the file while you're trying to work on it.
Use the LDB Viewer to check who else is connected to the database file.

In addition, if this is a split database on a network and you've deleted a
persistent connection, then opening a table may take quite a bit longer than
was previously the case. If it is a networked database, ensure that someone
hasn't switched you to 10 MB/s from 100 MB/s on the Ethernet when you
weren't looking.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
T

Tony Toews [MVP]

Bk said:
I have been developing an order entry system for the last few months and
Access has worked extremely well. I am keeping things very simple.

I was working on my data base this morning and everything was fine. I came
back this afternoon and now Access takes several minutes to open tables etc
where it was instantaneous up to this morning.

I repair/compacted the data base. It worked eventually but took a very long
time to process. I tried a backup copy of the data base and got the same
results.
Click to expand...

Did the IT department do anything to the server?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
B

Bk

THANK YOU ALL !!!!!

I found the problem after doing some research based on the replies you sent.

I am on a small LAN in my home office and had an external link to a table on
another workgroup member. That pc was hung up due to some power problems.

Rebooted the member and all is happy on my database again :)

Bk.

===========================================
 
T

Todos Menos [MSFT]

Access MDB is a piece of shit database

lose the training wheels; MDB has been obsolete for a decade

DAO and MDB are DED
 
T

Tony Toews [MVP]

Access MDB is a piece of s**t database

lose the training wheels; MDB has been obsolete for a decade

DAO and MDB are DED
Click to expand...

I think you meant to say DEAD. Which is, of course, wrong.

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Tony Toews [MVP]

Bk said:
THANK YOU ALL !!!!!

I found the problem after doing some research based on the replies you sent.

I am on a small LAN in my home office and had an external link to a table on
another workgroup member. That pc was hung up due to some power problems.

Rebooted the member and all is happy on my database again :)
Click to expand...

Now isn't that interested.

Was that table being used in the database in the forms that were sluggish? Or was it
not being used anywhere? I'm trying to understand if just having a table linked to
a non existent MDB, even if not being used, would cause such severe performance
problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
T

Todos Menos [MSFT]

how is it wrong?

MDB and DAO are DED.

MDB hasn't had a single improvement in 15 years.

lick my nuts you friggin retard

Access Data Projects are much better solution for 99% of the users
here

stable, reliable-- high performance

MDB just doesn't cut the cheese

what you're too stupid to see-- is that ADP is _EASIER_ than MDB



that's the fucking punchline
 
Top