We help IT Professionals succeed at work.
Get Started

Network folder permissions and Jet access.... possible??

Last Modified: 2012-05-05
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?



Watch Question
President / Owner
Most Valuable Expert 2017
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE