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 |
|
getut
Starting Member
7 Posts |
 Posted - 2007-07-31 : 16:13:58
|
| Is there a way to set what value is returned via app_name function?I have a SQL Server 2005 database that is written to by a MS Access front end... but I have users who have written their own access front ends that are manipulating data incorrectly. I want to allow the approved access applications but disallow the user written ones.Application roles are not an option because there is also a propietary software package that writes to the databases that we would not be able to modify to work with application roles. Allowing a whitelist of named applications is my only way to pull this off.How can I make MY access application report nameX instead of Microsoft Access or other similar generic name? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-31 : 16:15:09
|
| Tell the developers to make this change in their connection strings.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 16:16:05
|
| add "Application Name=YourAppName;" to the connection string_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 16:16:24
|
 _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
getut
Starting Member
7 Posts |
Posted - 2007-07-31 : 17:09:57
|
| I think these apps are much older.They have linked tables in Access. The table properties shows the ODBC connection string and in there, there is an APP=Microsoft Office 2003 area. That is an application that is reporting Microsoft Office 2003 to SQL server.Everytime I change that to something else, and save and exit the linked table, I come back in and it is back to that again. How can I get around that? |
|
|
|
getut
Starting Member
7 Posts |
Posted - 2007-08-20 : 11:50:04
|
| Does anyone have any idea?I'm changing the connection string for the linked table but it always reverts when saved. |
|
|
|
|
|
|
Setting value returned via app_name() function