Execute sp_password from Access?

[J]

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