SadOldMisterHam

if sql server is running on your local computer check that the shared memory protocol is enabled (using cliconfg). Check that the SQL Server service is started. Also, check how your connection string is trying to authenticate with the SQL server - eg if you are using trusted connection check …

good spot - also a nice thing to do is to use [CODE]replace(textbox.value, "'", "''")[/CODE] since users are prone to using the ' character in the most unlikely of places or alternatively go the whole hog and use parameters in the query eg [CODE]query = New OleDbCommand("INSERT INTO studenttable(sname,scourse,syear,ssemestor,sgrade)values(@P0, @P1, …

This link seems to indicate you need both the old password and the new password [URL="http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/4a2e342e-d7e4-4aaf-a1e3-f57248d9ebde"]http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/4a2e342e-d7e4-4aaf-a1e3-f57248d9ebde[/URL] So your code should be changed where you assign the value to strSQL: strSQL="ALTER DATABASE PASSWORD [" & newPassword & "] [" & oldPassword & "]" But your users will need to additionally supply …