 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Access running slow/frequently crashing
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 sh.t 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 On Apr 3, 6:50 am, jackijackijacki <jackijackija...@discussions.microsoft.com> wrote: > 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? Tony Toews' comes to the rescue yet again. Check out: http://www.granite.ab.ca/access/performancefaq.htm  SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > 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? 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? SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > 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 [quoted text clipped - 3 lines] > trying to work in the design view. > Is there anything I can do to improve the speed? '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 > The difference in speed should be barely noticeable, unless your database > design is poor. Never drag entire tables to do local processing. Instead [quoted text clipped - 18 lines] > > - Show quoted text - 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. SignatureArvin 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 On Apr 3, 9:32 am, "Arvin Meyer [MVP]" <a...@m.com> wrote: > The difference in speed should be barely noticeable, unless your database > design is poor. Never drag entire tables to do local processing. Instead [quoted text clipped - 24 lines] > > - Show quoted text - 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 > 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 [quoted text clipped - 66 lines] > > - Show quoted text - 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 [quoted text clipped - 66 lines] > > - Show quoted text - 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 > The difference in speed should be barely noticeable, unless your database > design is poor. Never drag entire tables to do local processing. Instead [quoted text clipped - 18 lines] > > - Show quoted text - 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. SignatureArvin 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 On Apr 3, 9:32 am, "Arvin Meyer [MVP]" <a...@m.com> wrote: > The difference in speed should be barely noticeable, unless your database > design is poor. Never drag entire tables to do local processing. Instead [quoted text clipped - 24 lines] > > - Show quoted text - 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 > 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. [quoted text clipped - 59 lines] > > - Show quoted text - 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 > 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. [quoted text clipped - 59 lines] > > - Show quoted text - On Apr 3, 9:50 pm, jackijackijacki <jackijackija...@discussions.microsoft.com> wrote: > 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? 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 >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! You also work for that company. Posting without disclosing any connection is highly unethical and sleazy. Tony SignatureTony 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/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.