Zotero database file
I noticed that the zotero.sqlite database file in my home directory is 3 years old, but I actively use, so I am unclear where Zotero is actually writing to. Where is Zotero writing too? We are performing major migrations and home directories here are actually network U drives, so we need to know. Thanks.
C:\Users\sklein\AppData\Roaming\Mozilla\Firefox\Profiles\4zzuknbj.default-1450125708703\zotero
If this is true, than it means I can only access locally from this workstation?
What you post is a typical default location, but you'll have to verify yourself that it's the one you actually use. You can move the database anywhere you want. I'd recommend against placing it on a network drive that allows simultaneous access from multiple locations, but that's not typically how Windows is set up in an institutional/enterprise setting, so probably nothing to worry about (but then, it's also atypical to have your Firefox on C: in such a setting, so better make sure).