Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2003-02-13 : 12:22:15
|
| HelloI have setup a series of views that need to be accessed from an Access database or from Excel. Normally I just link them using the ODBC connection to the server and all is fine, however, recently I have been getting the message The database engine can't find <view name>. Make sure it is a valid parameter or alias name that it doesn't include invalid parameters or punctuation, and that the name isn't too longI know there are no parameters as these are views, the only non alphabetic character I have used is the underscore which hasn't been a problem before which appears to leave the length of the view name. Some of the names are quite long, and as Access adds dbo_ to it may push it over the limit.My problem is that I have one or two views with longish names that all the other views depend upon. If I rename them I am going to have to go through all the others. Does anyone know of any quicker ways of doing this - perhaps some nifty code that manuipulates the VIEWS tablethanks in advancesteve |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2003-02-13 : 12:24:06
|
| P.S. I've tried renaming one of the views to a short name but that didn't work, probably because it was based on one with a longer name.thankssteve |
 |
|
|
|
|
|
Linking Views