Cannot run queries - Access falls over

[CW]

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?

 

[Golfinray]

I think that error message is usually associated with Windows, not with
Access. Not enough memory maybe?

 

[CW]

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!!

 

[Guillermo_Lopez]

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!!






- 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?

 

[aaron.kempf]

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

 

[Gina Whipp]

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

 

[Tony Toews [MVP]]

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
--
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/

 

[Alan]

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
he tries to run any of the Queries - then he gets the generic error message
"Accesshas 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?

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

 

[Tony Toews [MVP]]

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
--
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/