It's been a while since I watched the SQL seminar (I need to rewatch it), I do recall something about your login though which appears to be linked to this error. Perhaps try giving the seminar one more watch?

But this may give you some ideas to look at.
HERE

Thanks Adam,

I managed to put my login details again after the error, but then all of my forms were READ-ONLY, even though the properties have not changed.

At the moment I've ditched this and will re-visit. Although I've checked all the coding, and this is the only coding I've typed manually. It appears to be creating far more problems than it will solve at present.

Many thanks

Mark

This could be related to the recent Access Bug Alert.