Access Exit Problem

[Cordeiro82]

My database (Access 2002) is suddenly giving me a problem with a 'Create Table' Query that I created. previously the query used to run fine and I could make changes to it but now everytime I try to run the query in DESIGN mode it just exits the application all together. I tried shutting down my system and rebooting with no luck. Any suggestions?

 

[Golom]

Don't attempt to run DDL (Data Definition Language) queries from Design Mode. Save them and then run them by double clicking. In design mode the query designer attempts to convert a query to something that returns records and that's not possible for a CREATE TABLE query.

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[Cordeiro82]

Hello Golom... the query is running fine, but it is not allowing me to enter it in design mode to make any modifications. Everytime I try to enter the query in design or SQL view it exits the application. I have no idea what other method to use other than to delete that query and create a new one. Any other suggestions?