Execute sp_password from Access?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "J" <IDontLikeSpam@xxxxxxxxxxx>
Date: Thu, 27 Apr 2006 17:56:46 -0700

Hello. I'm not sure if this is the best place to ask this question but I
have an Access database with linked tables to SQL Server 2000. When the
user goes into view the data from a table it forces them to supply their SQL
login id and password from an odbc that's been set up. After they login
successfully I would like them to be able to change their own SQL login
password using the sp_password and was wondering what would be the best
security practice in executing the sp_password stored procedure? Is there a
way to do it using the current odbc sql connection that they're currently
using in like a pass through query or do I have to write vba code? I've
seen a couple examples on the web but it shows about having to respecify the
odbc dsn again and was hoping to not have to resupply this if possible.

Thanks in advance.

J

.

Prev by Date: Re: when admin open the file,others not able to open
Next by Date: dsn-less connection
Previous by thread: Re: Workgroup Administrator Question
Next by thread: dsn-less connection
Index(es):
- Date
- Thread

Relevant Pages

Re: Parameterized query problem
... Microsoft OLE DB Provider for SQL Server error '80004005' ... Cannot open database "Mydb" requested by the login. ... EXEC sp_helplogins 'aspuser' ...
(microsoft.public.inetserver.asp.db)
Re: dsn-less connection
... It worked pretty much as I was hoping in prompting the user for a SQL ... Server login and was able to remove the specific dsn that's in the odbc ... straight to the SQL Server login prompt? ... with the login prompt but the Use Trusted Connection is checked on. ...
(microsoft.public.access.security)
Re: Logging in irrespective of database access
... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
(microsoft.public.sqlserver.server)
Logging in irrespective of the database access settings
... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
(microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access
... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)