Query problem - click on design view, the DB shuts down 1

[verizonrep]

This is a first. There are three queries that I am trying to modify. When I right click and select the design view (or even highlight and click the icon), the entire database shuts down. No warning or anything. It doesn't do this on any other query, just these three.

Any ideas?


Thanks,

Will

 

[Golom]

Have you tried compacting your database? Sounds like a corruption issue.

 

[verizonrep]

Yep. Did it twice.

 

[Golom]

Guess there's always DAO

Dim qd  As DAO.QueryDef
Dim SQL As String
Dim QueryName As String
QueryName = "myQuery"
Set qd = CurrentDB.QueryDefs(QueryName)
SQL = qd.SQL
CurrentDB.QueryDefs(QueryName).Remove
Set qd = New DAO.QueryDef
qd.Name = QueryName
qd.SQL = SQL
CurrentDB.QueryDefs.Append qd

on the assumption that there's something about these things that's causing Access to die horribly.

 

[verizonrep]

Big question of the day is that this DB has been running fine for the longest time...I wonder why it's having problems now?

 

[Golom]

JOOTCTTHATT?

(Just One Of Those Computer Things That Happens All The Time?)