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

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?

Thanks,

Steve

ClayCanvasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Hum, let me it answer it this way:

1. For jet locking to work properly, a user needs full read/write/delete priv for the directory where the db resides. Also for the workgroup folder.

2. Within the db, any data can be opened via VBA code with a DenyRead, DenyWrite option, or the dbReadOnly lock argument. So with code, you can allow users to only read data or deny them access.

3. With a web server, it is the web engine that works with the database. Each user connecting to a web site works through the server. As far as JET is concerned, there is only one user.

JimD.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ClayCanvasAuthor Commented:
Jim,
Thanks for the quick response.  When accessing a database via VBA is there a difference in how the Jet engine works (functional,performance or otherwise) when an Access database is located in a folder inside the webserver (Inetpub) versus being in any other folder on a network?
Steve
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Thanks for the quick response.  When accessing a database via VBA is there a difference in how the Jet engine works (functional,performance or otherwise) when an Access database is located in a folder inside the webserver (Inetpub) versus being in any other folder on a network?>>

  No.

JimD.
0
ClayCanvasAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.