 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Cannot run queries - Access falls over
A colleague's PC has expired and he has brought his home PC into the office. He has Access 2003 and can run all of our fairly extensive mdb except when he tries to run any of the Queries - then he gets the generic error message "Access has encountered a problem and needs to close". We have run Compact and Repair, lowered his security levels to Low, and I can't think of what else could be causing this, or how to resolve it. Any suggestions, please? I think that error message is usually associated with Windows, not with Access. Not enough memory maybe? > A colleague's PC has expired and he has brought his home PC into the office. > He has Access 2003 and can run all of our fairly extensive mdb except when [quoted text clipped - 3 lines] > can't think of what else could be causing this, or how to resolve it. > Any suggestions, please? Thanks but no, I really don't think it's anything to do with Windows. That message will be seen within any application that is experiencing a problem and it relates to something that's going on (or not!) within that particular piece of software. And the PC is only 6 months old, with dual core processor and 2 gig of RAM, so it's not a performance issue. Gotta be something else, that it doesn't like just the queries, but who knows what!! > I think that error message is usually associated with Windows, not with > Access. Not enough memory maybe? [quoted text clipped - 6 lines] > > can't think of what else could be causing this, or how to resolve it. > > Any suggestions, please? > Thanks but no, I really don't think it's anything to do with Windows. That > message will be seen within any application that is experiencing a problem [quoted text clipped - 15 lines] > > - Show quoted text - Remember to make a copy of your MDB file before messing around with it. Does it run other MDBs? Does it run other queries? Try creating a new query and run it? Does the mdb have any code? Did you try to compile the code? Is your windows updated all the critical updates? Move to ADO / SQL / ADP. DAO / MDB is too unstable to be useful.. I'm not even positive that DAO is supported in an x64 environment. -Aaron > A colleague's PC has expired and he has brought his home PC into the office. > He has Access 2003 and can run all of our fairly extensive mdb except when [quoted text clipped - 3 lines] > can't think of what else could be causing this, or how to resolve it. > Any suggestions, please? CW, Three things come to mind: 1. Make sure the PC has all the latest patches for Access and Windows. 2. Open the database and have someone check the refrences for ones tagged as 'MISSING'. Also have them check the references for one that works and for the one that doesn't work. 3. Corruption, see: Tony Toews corruption symptoms: http://www.granite.ab.ca/access/corruption/symptoms.htm Tony Toews has an excellent web page on database corruption: http://www.granite.ab.ca/access/corruptmdbs.htm Allen Brown also has excellent info on corruption: http://allenbrowne.com/ser-47.html Jerry Whittle has a white paper in a Word document named Fix Corrupt Access Database towards the bottom this page: http://www.rogersaccesslibrary.com/OtherLibraries.asp You also didn't mention, is this database split? If it isn't it should be, see: http://members.shaw.ca/AlbertKallal/Articles/split/index.htm  SignatureGina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II >A colleague's PC has expired and he has brought his home PC into the >office. [quoted text clipped - 6 lines] > can't think of what else could be causing this, or how to resolve it. > Any suggestions, please? Note that Aaron's opinion is seldom shared by other folks. Furthermore ADPs have not had any enhancements in recent versions and should be considered to be a dead end method. 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/ > A colleague's PC has expired and he has brought his home PC into the office. > He hasAccess2003 and can run all of our fairly extensive mdb except when [quoted text clipped - 3 lines] > can't think of what else could be causing this, or how to resolve it. > Any suggestions, please? Hi, Sounds like the mdb file is damaged or something. If you don't have a backup, I think you may try Advanced Access Repair at http://www.datanumen.com/aar/ This tool is rather useful in salvaging damaged Access MDB files. Alan >Sounds like the mdb file is damaged or something. If you don't have a >backup, I think you may try Advanced Access Repair at http://www.datanumen.com/aar/ >This tool is rather useful in salvaging damaged Access MDB files. 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.