?
Solved

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

Posted on 2008-11-03
4
Medium Priority
?
431 Views
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?

Thanks,

Steve

0
Comment
Question by:ClayCanvas
  • 2
  • 2
4 Comments
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 22872971
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
 

Author Comment

by:ClayCanvas
ID: 22873009
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
 
LVL 59
ID: 22873023
<<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
 

Author Closing Comment

by:ClayCanvas
ID: 31512951
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question