I don't know much about the Jet engine. What I would like to be able to do if it is possible is grant access via VBA to read/write to an Access database that's on a webserver (IIS). While allowing write access via the VBA code I would like to limit access to the actual network folder in the same way the webserver allows access via a webpage to make edits to a database but secures the folder the database is located in... is something like that possible?
I'm utilizing VBA in an Excel file and writing to the database but I hoping not to have to give every user "write" access to the actual folder the database resides in (on the IIS web server) in order for the VBA code to work. Or maybe another way of saying it is to say I'm wondering if the way the webserver controls access to the database folders can be utilized via VBA with an Excel file instead of a web page.
I realize I can password protect the Access file. I'm just concerned about giving access to the folder the database resides in currently.
I hope I'm making sense?