I'm not sure about changing the language in Access only. You can however change the language ( e.g. to Spanish) in MSOffice programs altogether.
You can try this :
On the Windows Start menu, point to Programs, point to Office Tools, and then click Microsoft Office Language Settings. On the Enabled Languages tab, select the check boxes next to the languages you want.