password change form compatibility

[jtkjames]

http://www.access-programmers.co.uk/forums/showthread.php?t=111547

this is an old thread, now closed, but still useful I think.

I have tried to copy and paste the form into my Access database with User Level Security, but I get various errors when I run it (On Load Event - User Defined Type Not Defined)

Does anyone else use it and have problems? Im using Access XP with an Access 2002 DB.

i note that it is called "Access9db" which to me suggests it could be that the form/vba is incompatibe with later versions or something?

 

[vbaInet]

What line does it highlight exactly? This would normally be a reference issue.

 

[jtkjames]

Thats the weird thing, it doesnt highlight any line. It's a popup message. and a similar message appears whenever i press any button on the form. Also, it won't close, i have to task manager kill msaccess.exe as its read only (even if i change form properties to not be popup, it ignores these changes).

 

[vbaInet]

Go into the code and comment out all the error handlers. It will highlight then.

 

[jtkjames]

Sorry about the delay in replying, I have been on leave for a few days following something of a personal disaster. Anyway, I've tried commenting out the error handling, but still can't figure it out. However, I have a workaround (basically linking a button to the actual account settings window, then ensuring permissions are set correctly).

 

[vbaInet]

You would also need to comment out the error handler at the routine that calls the code. However, I'm glad you found a workaround.

I hope things go well for you.