If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
" is not a valid name
I have the 60-day trial version of Office 2007 and am having issues with
Access 2007. When I create (or attempt to modify) queries of tables in a split database I get the ' " is not a valid name' error message. The query is actually created, after I clear the error message, and appears to work, but if I try to re-open it in design view, I can't. In some cases I can open in SQL view, but sometimes that doesn't work either. I can successfully create the same query in the backend (i.e. local to the tables). I've searched all over the web - plenty of people seem to be experiencing this problem, but there are no real fixes out there. I've checked my references and tried Autocorrect on and off as suggested in the past. It seems most of the other people experiencing this are trying to query Excel or Paradox data. My gut feeling is that the problem is some wonderful new 'security' feature that's affecting communication between Access and the data source. Can anyone shed any light on this? Without a solution, I won't be buying this product when my trial expires. Thanks, Sharon |
#2
|
|||
|
|||
" is not a valid name
Sharon,
I have frequently experienced the same " is not a valid name problem when using linked tables in Access 2007 (Service Pack 1). The same bug occurs when you try to delete the table link, making it impossible to delete the link. This problem is more likely to occur with the database you are linking to, the database in which the original table resides, is protected by user-level security, although others have reported the same problem in instances where user-level security is not in use. You may want to report your own experience to the Microsoft Office Feedback web page found at: https://feedback.office.microsoft.co...key=office2007 I am hoping that if enough people report the problem to Microsoft, they will then be more likely to investigate and fix it. Stuart Bratesman, Jr., MPP Muskie School of Public Service Univ. of Southern Maine Portland, Maine "Sharon Peterson" wrote: I have the 60-day trial version of Office 2007 and am having issues with Access 2007. When I create (or attempt to modify) queries of tables in a split database I get the ' " is not a valid name' error message. The query is actually created, after I clear the error message, and appears to work, but if I try to re-open it in design view, I can't. In some cases I can open in SQL view, but sometimes that doesn't work either. I can successfully create the same query in the backend (i.e. local to the tables). I've searched all over the web - plenty of people seem to be experiencing this problem, but there are no real fixes out there. I've checked my references and tried Autocorrect on and off as suggested in the past. It seems most of the other people experiencing this are trying to query Excel or Paradox data. My gut feeling is that the problem is some wonderful new 'security' feature that's affecting communication between Access and the data source. Can anyone shed any light on this? Without a solution, I won't be buying this product when my trial expires. Thanks, Sharon |
Thread Tools | |
Display Modes | |
|
|