Access crashes when I try to give a table an alias in design view

I am using design-view to make queries and I want to give a table name an alias, but after I create the alias, Access immediately crashes and shuts down. please advise开发者_StackOverflow中文版

thank you very much nathaniel Access 2007, OS XP

I have had the same issue. I right click the table name in design view of a query, then change the Alias property (usually because I'm referencing the same table twice). I click back on the main body of the query or try and take another action, and Access completely crashes.

I have found several things which help.
First - work on a local copy of the database, especially if I'm working in a SQL statement behind a form or report. Takes network interruptions out of the issue. Second - if I can figure out the SQL without working in design view, alias my table by directly modifying the SQL instead of working in query design view. Third - if I must alias the table in query design view (which is usually me), click save immediately after changing the alias in the Property Sheet of the table, before doing anything else, while my cursor is still in the Alias property (Do Not Pass Go, Do Not Collect $200).

Hope this helps.

I had the same problem and discovered that the following worked:

Enter the ALIAS on the property sheet Click in the SOURCE field Click on the X to close the Property Sheet properties

Not sure why it works but it did for me.