Access running slow/frequently crashing

  • Thread starter Thread starter jackijackijacki
  • Start date Start date
J

jackijackijacki

Yesterday I split my database, with the back end on the company server and
the front end on the individual pc's. However, macros and code are now much
slower in running on forms and the program has crashed several times when I'm
trying to work in the design view.
Is there anything I can do to improve the speed?
 
yah no shit it's running slow and frequently crashes.

That is why I've been reccomending that -everyone- move to SQL Server.

For performance and reliability / availability reasons.

Upsize to SQL Server, I don't care if you have to take a friggin class
on SQL Server to get it done.

That is the only way you'll get performance and reliability back.

-Aaron
 
The difference in speed should be barely noticeable, unless your database
design is poor. Never drag entire tables to do local processing. Instead
make sure that you bring the indexes in a filtered query.

How many users do you have? If there are more than a few, indexing becomes
critical.

How stable is your network? Do other very large files crash or corrupt?

Ate you trying to design tables while others are updating the database?
 
'unless the design is poort'
or
'there is a vpn requirement'
or
'wireless cards act funny, and Access crashes'
or
'you want to run your database-- as is- a decade from now'
or
'you want to use industry-best tools for optimizing indexes'.

I strongly disagree kid.
It has nothing to do with design.

My network is perfectly stable. I don't have any other large files
that ever crash, no.

Indexing becomes critical.
Of course.. 'Access doesn't really support indexing'.
and 'Access doesnt' really support the proper USAGE of indexing'.

Thanks
 
what about.. if your schema 'just doesn't fit' inside of Access?

What if.. you want to see what's really going on in a mission-critical
database?

What if you want to use replication?
What if you want to take backups _WHILE_ people are using the
database?
What if you want to use database mirroring?
Or Database Snapshots.
Or Reporting Services.

Do you _LIKE_ running reports by hand?

Or do you want them to just automagically get emailed to you once a
night?

Access doesn't support 1/10th of the functionality of SQL Server.

Sorry-- but you lose.

-Aaron
 
Obviously, you have no idea what you are talking about when it comes to
Access/JET. Nor do you have any idea who you are dealing with when you refer
to me as "kid". I am surely old enough to be your father, with more years
experience in databases than you are old.

Just to make it absolutely clear, everything you have said below is patently
incorrect with the exception of it being inadvisable to use Access (or any
database) with bound records on an air card. That is just as true, btw, if
you use bound forms with a SQL-Server back-end. A stable network, which does
not include anything like aircards, is a requirement for bound datasets.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

'unless the design is poort'
or
'there is a vpn requirement'
or
'wireless cards act funny, and Access crashes'
or
'you want to run your database-- as is- a decade from now'
or
'you want to use industry-best tools for optimizing indexes'.

I strongly disagree kid.
It has nothing to do with design.

My network is perfectly stable. I don't have any other large files
that ever crash, no.

Indexing becomes critical.
Of course.. 'Access doesn't really support indexing'.
and 'Access doesnt' really support the proper USAGE of indexing'.

Thanks
 
Your answer in no way is helping the poster to sort out his problem. If you
can't be helpful, please refrain from wasting everyone's time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

what about.. if your schema 'just doesn't fit' inside of Access?

What if.. you want to see what's really going on in a mission-critical
database?

What if you want to use replication?
What if you want to take backups _WHILE_ people are using the
database?
What if you want to use database mirroring?
Or Database Snapshots.
Or Reporting Services.

Do you _LIKE_ running reports by hand?

Or do you want them to just automagically get emailed to you once a
night?

Access doesn't support 1/10th of the functionality of SQL Server.

Sorry-- but you lose.

-Aaron
 
my words are 10 times more helpful.. _DAILY_ than the volumes of crap
that you so called MVPs preach.

It's ok-- SQL Server is _OBVIOUSLY_ more popular.. I don't see Access
_ANYWHERE_ near Tpc.org

-Aaron
 
what the hell are you talking about Arvin?

you're contradicting every other idiot around here.

Access doesn't support wireless.. or more importantly; when Access
throws a tissyfit.. you dipshits blame it on things like 'the
network'.

I'm a certified DBA.

Are you certified?

You're an idiot that is stuck in the 80s.

Stick a fork in it, loser!

-Aaron
 
what about.. if your schema 'just doesn't fit' inside of Access?

What if.. you want to see what's really going on in a mission-
critical
database?


What if you want to use replication?
What if you want to take backups _WHILE_ people are using the
database?
What if you want to use database mirroring?
Or Database Snapshots.
Or Reporting Services.


Do you _LIKE_ running reports by hand?


Or do you want them to just automagically get emailed to you once a
night?


Access doesn't support 1/10th of the functionality of SQL Server.


Sorry-- but you lose.


-Aaron
 
what about.. if your schema 'just doesn't fit' inside of Access?

What if.. you want to see what's really going on in a mission-
critical
database?


What if you want to use replication?
What if you want to take backups _WHILE_ people are using the
database?
What if you want to use database mirroring?
Or Database Snapshots.
Or Reporting Services.


Do you _LIKE_ running reports by hand?


Or do you want them to just automagically get emailed to you once a
night?


Access doesn't support 1/10th of the functionality of SQL Server.


Sorry-- but you lose.


-Aaron
 
Yesterday I split my database, with the back end on the company server and
the front end on the individual pc's.  However, macros and code are now much
slower in running on forms and the program has crashed several times when I'm
trying to work in the design view.  
Is there anything I can do to improve the speed?
Click to expand...

Hi,

I think the mdb file is damaged. Why not try Advanced Access Repair at
http://www.datanumen.com/aar/ ? It recovers several important Access
MDB files for me and is really helpful!

Alan
 
Alan said:
I think the mdb file is damaged. Why not try Advanced Access Repair at
http://www.datanumen.com/aar/ ? It recovers several important Access
MDB files for me and is really helpful!
Click to expand...

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top