Application Role & 2nd Database

From: Jeff Price (price.9_at_osu.edu)
Date: 02/11/04 

Date: Tue, 10 Feb 2004 18:56:54 -0500

I'm trying to use application roles for the 1st time and have a problem.
Most of the select statements I use reference tables in a separate database.
After reading the BOL I find that this only works through the GUEST account.
Drat!

Any suggestions to fix this? I'm considering setting up views in the local
DB, but this will involve changing the code and creating the views and I
still don't know if it will work. 

-- 
Jeffrey R. Price
Database Manager
Computing & Communication Services
Max M. Fisher College of Business
The Ohio State University
320F Mason Hall
250 W. Woodruff Avenue
Columbus, OH  43210-1309

Relevant Pages

  • Re: Update Sheet1
    ... you need to put the function in a new cell because it needs to ... reference both the old price and the new price. ... problem is that I do not have space for another column in Sheet 1, ... Reference Number Description Price/Eur New Price/Eur ...
    (microsoft.public.excel.programming)
  • Re: p-Lower central series, relevance?
    ... theory, particularly when computing with finite p-groups, where it is ... There is a very efficient algorithm known as the nilpotent quotient, ... As a general reference and pointer to other references, ... Derek Holt. ...
    (sci.math.research)
  • Re: How do I use references to another worksheet when new rows are
    ... The previous worksheet is a competitor price listing for 2004 and we are ... "Frank Kabel" wrote: ... >> reference is therefore disrupted. ...
    (microsoft.public.excel.misc)
  • Re: Range name confusion
    ... works when your reference to the range name is in any row of the range. ... I have a general question regarding ... > named "Price". ... > and copy it down, the formula works correctly, multiplying ...
    (microsoft.public.excel.misc)
  • Re: Not sure how to do this...
    ... Microsoft Excel MVP ... I tried to build a table and then reference cells in the table inside the ... If I can't get the cell reference ... changes to the table than it is to edit the formula if /when the price ...
    (microsoft.public.excel.misc)