Hello guys,
I am a newbie to start with. I am struggling to deliver at list he minimum of security for my Access db.
Initial info:
1. DB is in corporate shared network folder with Read/Modify
2. I don't think I can really edit any security settings from the level of Windows for it
3. Excel form and password protected DB are in the same folder so every user can do anytnig with DB
The general process is:
1. User fills Excel based form and submits
2. After submission macro makes connection to the password proteced DB (password is hardcoded in pass protected VBA) and injects gathered data
It is surely not enough, what else could I do?
Ideally I'd like to set Read only for the network folder but can I bypass this in VBA code granting users Write/Append only?
Regards,
Witek