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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neimad - 22 Feb 2005 17:04 GMT

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

Reply to this Message

TC - 23 Feb 2005 04:06 GMT

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

Reply to this Message

Neimad - 23 Feb 2005 05:59 GMT

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...

Reply to this Message

Lynn Trapp - 23 Feb 2005 14:52 GMT

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.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> 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...

Reply to this Message

TC - 24 Feb 2005 04:53 GMT

Neat! I take it you mean, to run a copy of Access *on the server* to
hold the database open?

TC

Reply to this Message

Lynn Trapp - 24 Feb 2005 13:00 GMT

Yes I do.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Neat! I take it you mean, to run a copy of Access *on the server* to
> hold the database open?
>
> TC

Reply to this Message