 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / April 2005Functions, Views or Stored Procedures
I have upsized a database, and now I need to change 1 thing in every query. Problem is, functions don't seem to be editable (at least not in SQL). How can I change 1 table to a different table in a function? Thanks, Drew Unless you are using an old version of ADP (2000?) or that you have a permission problem or that you have some mixe-up with dbo. or another user name; functions are editable under DAP. You should provide us with more information.  SignatureSylvain Lafontaine, ing. MVP - Technologies Virtual-PC >I have upsized a database, and now I need to change 1 thing in every query. >Problem is, functions don't seem to be editable (at least not in SQL). [quoted text clipped - 3 lines] > Thanks, > Drew I am working upsizing a Staff Training database, which uses linked tables to link to the Staff Core database. I already have the Staff Core database on SQL Server and now all I need to do is remove all the links to the old Staff Core MDB and make them link to the new Staff Core SQL database. With the functions, there is no SQL statement to edit, so I am unsure of how to accomplish this task. Thanks, Drew > Unless you are using an old version of ADP (2000?) or that you have a > permission problem or that you have some mixe-up with dbo. or another user [quoted text clipped - 10 lines] >> Thanks, >> Drew Click on the SQL button available on the Function Design toolbar. Don't mix it with the Verify SQL Syntax button. SignatureSylvain Lafontaine, ing. MVP - Technologies Virtual-PC >I am working upsizing a Staff Training database, which uses linked tables >to link to the Staff Core database. I already have the Staff Core database [quoted text clipped - 21 lines] >>> Thanks, >>> Drew BEAUTIFUL! Thanks so much... I was starting to worry! I was looking for the SQL view in the place that it usually is! Thanks, Drew > Click on the SQL button available on the Function Design toolbar. Don't > mix it with the Verify SQL Syntax button. [quoted text clipped - 25 lines] >>>> Thanks, >>>> Drew |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.