Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
Reload this Page Access Self Program Shutdown
Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Fill in a brief D.W. Simpson Registration Form
to be contacted when our jobs meet your criteria.


Reply
Page 2 of 3 < 12 3 >
 
Thread Tools Display Modes
  #11  
Old 11-13-2007, 11:00 AM
Old Timer's Avatar
Old Timer Old Timer is offline
Member
SOA AAA 		 
Join Date: Sep 2001
Location: The Great East
Posts: 1,559
Default
If you have to recreate the query, try opening the query in SQL format and copy and paste the SQL code to a text file so that you have it saved and can recreate the query again more quickly next time.
__________________
Life is chaos personified.
Reply With Quote
  #12  
Old 11-13-2007, 01:22 PM
SamChevre's Avatar
SamChevre SamChevre is offline
Member
  
Join Date: Jan 2003
Location: Virginia
Posts: 2,141
Default
Can you open as SQL and post the SQL here?
__________________
Liberals tend to view themselves as live-and-let-live people.... We’re the nice guys. We believe in tolerance, diversity, and letting people be what they have to be. It’s hard for us to credit the idea that someone could be afraid of us.

Someone is. And for good reasons. Understanding that uncomfortable fact is the first step towards grasping what has been going on in this country’s politics for the last quarter century. Red Family, Blue Family
Reply With Quote
  #13  
Old 11-13-2007, 02:02 PM
GadgetGeek's Avatar
GadgetGeek GadgetGeek is offline
Note Contributor
SOA AAA 		 
Join Date: Sep 2001
Location: I'm here, where are you?
Studying for a way to escape
College: Illinois College ('87)
Favorite beer: Stag
Posts: 10,518
Default
Another thought is that your actual installation of Access has somehow damaged itself. I believe on the help menu there is a repair option? Or on one of the menus. This isn't the "compact and repair" for the database, this is a repair for the software itself.
__________________
Some people are like clouds. When they disappear, it's a brighter day.
Reply With Quote
  #14  
Old 11-13-2007, 03:00 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
SOA AAA 		 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for CPD
Posts: 29,636
Default
Quote:
Originally Posted by GadgetGeek View Post
Another thought is that your actual installation of Access has somehow damaged itself. I believe on the help menu there is a repair option? Or on one of the menus. This isn't the "compact and repair" for the database, this is a repair for the software itself.
<insert head scratching icon here - MS has a repair function for fixing its own software??>
__________________
Carol Marler, FSA, MAAA, A Dedicated Actuary
Just My Opinion (Although this statement is my opinion, and I am an actuary, it's still not a statement of actuarial opinion, and you really shouldn't rely on it.)
Updated quotes Apr 4:
Spoiler:
Quote:
Originally Posted by Arthur Kade View Post
Actuaries (as a general rule) are uniquely UNqualified to work with derivatives.
Quote:
Originally Posted by Dr T Non-Fan View Post
learning what the data are, what they mean, why they are plural, etc.
Quote:
Originally Posted by SamTheEagle View Post
StompStomp kept saying "Happy Day!" rather than Happy Birthday. It was cute.
Quote:
Originally Posted by Buck View Post
Machines do not make human-errors but make machine-errors; humans do not make machine-errors but make human-errors ... even when the technology is there, it'd be a tough call as to which makes driving safer.
Quote:
Originally Posted by Klaymen View Post
Life is a bunch of IF statements
Reply With Quote
  #15  
Old 11-13-2007, 03:12 PM
SouthOfSanity SouthOfSanity is offline
Member
  
Join Date: Jul 2005
Location: Massachusetts
Posts: 423
Default
Quote:
Originally Posted by SamChevre View Post
Can you open as SQL and post the SQL here?
No, I can't. In order to open as SQL, I have to open the query on Design view, then choose the SQL option from there. I can't open the query on the Design view. So I actually have to recreate it from scratch right now.
Reply With Quote
  #16  
Old 11-13-2007, 08:31 PM
vanguard_wang vanguard_wang is offline
Member
SOA 		 
Join Date: Nov 2003
Location: Philadelphia
Posts: 76
Default
try this way. (imported to a new MDB file)...

Step1, create a new empty Access database (MDB) file. let's name it tmpDB1.mdb
Step 2. open tmpDB1.mdb, then click the "Import"
--Import the query from your original Access database into tmpDB1.mdb
--If needed, also import all Tables (only Table Definition/Structure should be ok, no need to import the data) into the new tmpDB1.mdb.

Then check if you can open the query in the tmpDB1.mdb.

Hope it works
Reply With Quote
  #17  
Old 11-14-2007, 07:08 AM
SouthOfSanity SouthOfSanity is offline
Member
  
Join Date: Jul 2005
Location: Massachusetts
Posts: 423
Default
Quote:
Originally Posted by vanguard_wang View Post
try this way. (imported to a new MDB file)...

Step1, create a new empty Access database (MDB) file. let's name it tmpDB1.mdb
Step 2. open tmpDB1.mdb, then click the "Import"
--Import the query from your original Access database into tmpDB1.mdb
--If needed, also import all Tables (only Table Definition/Structure should be ok, no need to import the data) into the new tmpDB1.mdb.

Then check if you can open the query in the tmpDB1.mdb.

Hope it works
Thanks. Just tried that, but didn't work either.
Reply With Quote
  #18  
Old 11-14-2007, 09:19 AM
Old Timer's Avatar
Old Timer Old Timer is offline
Member
SOA AAA 		 
Join Date: Sep 2001
Location: The Great East
Posts: 1,559
Default
What happened? It crashed when you opened the query?
__________________
Life is chaos personified.
Reply With Quote
  #19  
Old 11-14-2007, 12:55 PM
SouthOfSanity SouthOfSanity is offline
Member
  
Join Date: Jul 2005
Location: Massachusetts
Posts: 423
Default
Quote:
Originally Posted by Old Timer View Post
What happened? It crashed when you opened the query?
Yep. The program shuts down by itself when I try to open it. All the other applications on the computer are not affected at all when it happens though; so only Access crashes, not the whole computer.
Reply With Quote
  #20  
Old 11-14-2007, 01:19 PM
DudeMan's Avatar
DudeMan DudeMan is offline
Member
  
Join Date: Jan 2006
Location: teh Po'
Studying for shts&ggles
Favorite beer: Ginger Beer
Posts: 11,533
Default
I had this same problem about a year ago. I think the query had a bunch of joins between 2 (or more) tables/queries. I believe I had changed the names of some of the tables/queries and Access freaked out and crashed whenever I tried opening the query
Reply With Quote
Reply
Page 2 of 3 < 12 3 >

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 04:43 PM.

Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.38675 seconds with 7 queries