If your using Access 2000, this is a known quirk (putting it kindly). To get around it, go to Tools, Options, General, and turn off the Name AutoCorrect feature.
You'll need to do this on every PC. If you want to do this from code, you need something like this when you open the database:
Public varTrackSetting As Variant
Public varPerformSetting As Variant
Public Const strTrackAC As String = "Track name AutoCorrect info"
Public Const strPerformAC As String = "Perform name AutoCorrect"
Application.SetOption strTrackAC, False
Application.SetOption strPerformAC, False