This is very bizarre.

I've just retested my code against all servers (2005/2008/2012) using a test login and it's all working fine.

I've created the user, adjusted the permissions and then deleted my test user and it's all working according to plan.

I've now got a fully-working database front end to manage users across multiple servers and it's only 732KB (Access 2010). 🙂