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 |
|
Bill Hallinan
Starting Member
1 Post |
 Posted - 2002-07-10 : 11:00:47
|
| I'm using Acess XP and SQL 2000. I have a user-defined scalar function that returns the value "A" and is located on the SQL Server. When calling this function in the Access XP ADP as as a user who is the dbo and also a system administrator, the function returns "A". If the same function is called by a user who is the dbo and NOT the system administrator, the function returns "". To open the function I double click on it in the Access XP query window. What is going on? Is there a permission that needs to be granted to the user who is the dbo and NOT the system administrator? Is there a driver bug? Any help would be appreciated. Thank you in advance.Here's the function:ALTER FUNCTION dbo.ufnReturnA ()RETURNS char(1)ASBEGIN RETURN 'A'END |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-07-10 : 11:32:35
|
quote:
To open the function I double click on it in the Access XP query window.
I'll admit an unfamiliarity with Access, I work exclusively with SQL Server, but is it possible that you're not executing the function when you "open" it but rather trying to modify its definition? Have you tried to reference the function in a query?Jonathan Boott, MCDBA |
 |
|
|
|
|
|
Perplexing User-Defined Scalar Function Problem