Auto close of DB when queries are changed

S

stickandrock

Just recently when editing an existing query when I save the database closes
down. When I get back into the db my changes we're not applied. the same
thing happens when I change a report.

Any thoughts???
 
S

stickandrock

Still occurring.....

When I change a query or report than save it, the database closes out.
Almost seems like it is locked for changing. But if I use one of my forms to
edit data it changes the data with no problem.
 
S

stickandrock

This one works...
GT_January_Appr_Hrs: IIf([Sub Project] Like "I8101*",[Approved hrs
I8101]![Jan],IIf([Sub Project] Like "Small Batch*",[Approved hrs
I6000]![Jan]+[Approved hrs I7000]![Jan],IIf([Sub Project] Like
"I8000*",[Approved hrs I8000]![Jan],IIf([Sub Project] Like "I8100*",[Approved
hrs I8100]![Jan],99))))

This one doesn't...
GT_January_Appr_Hrs: IIf([Sub Project] Like "I8101*",[Approved hrs
Dview]![Jan],IIf([Sub Project] Like "Small Batch*",[Approved hrs
I6000]![Jan]+[Approved hrs I7000]![Jan],IIf([Sub Project] Like
"I8000*",[Approved hrs I8000]![Jan],IIf([Sub Project] Like "I8100*",[Approved
hrs I8100]![Jan],IIf([Sub Project] Like "Dview*",[Approved hrs
Dview]![Jan],99)))))

When I change the query to look like the changed one it closes the database
when I save the query.

Is there a max length of a field.
 
T

Tony Toews

stickandrock said:
Just recently when editing an existing query when I save the database closes
down. When I get back into the db my changes we're not applied. the same
thing happens when I change a report.
Click to expand...

Try importing all your objects into a new database.

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
 
Top