0

My MSAccess database is located on a shared network folder; This function works perfectly… but only for me – the database owner For my colleague’s I get the error #name

Any ideas?

Found this function here!

Function UserNameWindows() As String
    UserNameWindows = VBA.Environ("USERNAME") & "@" & VBA.Environ("USERDOMAIN")
End Function
Shai Rado
  • 33,032
  • 6
  • 29
  • 51
Emanuel
  • 41
  • 1
  • 6
  • You should really have a separate front end database locally, on each users machine.Split your database -have a read here for just some of the reasons http://www.techrepublic.com/blog/10-things/10-plus-reasons-to-split-an-access-database/ – Minty Jul 04 '17 at 13:41
  • I am very inexpedient with VBA. So I split the database in the network folder and then I copy the front end to every workstation? – Emanuel Jul 04 '17 at 14:02
  • After reading 10 reasons to split… I finally understand… Thanks a lot! – Emanuel Jul 04 '17 at 14:13
  • Yes - in simplest terms. Please take a backup copy before you do anything at all. You basically need to split out your data tables from your forms/queries and reports. Please read up carefully and backup before making wholesale changes. – Minty Jul 04 '17 at 14:14
  • It is already working. Thank you very much! – Emanuel Jul 04 '17 at 14:44

0 Answers0