select queries in read-only avoiding the creation of a ldb

  • Thread starter Thread starter Neimad via AccessMonster.com
  • Start date Start date
N

Neimad via AccessMonster.com

HI,

I am working on a small intranet application, but working on client-side on
a File server. Html pages use vbscript to run sql queries in several db in
a unique folder.
The objective is to allow users to view data, but they should not have
write/delete/create rights on the folder where the databases are stored for
security reasons.
Of course this is a problem as normally the lock file is created when one
person makes a query... An exclusive access is not an option either...
I heard there could be a way by creating a read-only mde file ?
Does someone has another solution (high-level direction would already be a
great help).
Thanks
Neimad
 
I'm not positive what your options are here, but I can tell you that
converting the database to MDE format, will not help. Lock files are
nothing to do with what format (MDB or MDE) the database is in.

HTH,
TC
 
yes, indeed the ldb is created also when using an mde.
My hope was that there could be a way to limit the access file in a kind of
read-only version that would not need the creation of a lock file...
 
There is an undocumented way to avoid the creation of the .ldb file, but you
have to be willing to have a database open all the time on your server. If
you open a copy of the database on the server with the /ro AND /excl
switches, the lock file will not be created and other users will still be
able to open the database. I'm not sure what implications this may have for
other security issues you have, but you could give it a try and see if it
accomplishes what you want. However, do lots of testing before you implement
this approach in your production environment.
 
Neat! I take it you mean, to run a copy of Access *on the server* to
hold the database open?

TC
 
Back
Top