• I think Access/VBA supports Environ$ - if so calling Environ$("computername") should work. Type set at a command prompt to see all variables accessible using this method. If not, you can always get it with an API call, which I'd have to dig around for.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/