Functions, Views or Stored Procedures

  • Thread starter Thread starter Drew
  • Start date Start date
D

Drew

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.
 
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
 
Click on the SQL button available on the Function Design toolbar. Don't mix
it with the Verify SQL Syntax button.
 
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
 
Back
Top