MDE File Permission

[KS]

As the folder contains MDE has to grant Read/Write/Execute permission, the
MDE file may be overwritten. Is there any ways to prevent MDE file from
overwritten?

 

[Tom van Stiphout]

On Sun, 18 May 2008 09:05:01 -0700, KS <[email protected]>
wrote:

No.
Fortunately you have a backup handy.

-Tom.

 

[Keith Wilby]

As the folder contains MDE has to grant Read/Write/Execute permission, the
MDE file may be overwritten. Is there any ways to prevent MDE file from
overwritten?

Make the folder Read-Only and have the users' shortcut point to a batch file
that downloads the mde to their local drive and then opens it. I can post a
sample batch file if you like.

Keith.
www.keithwilby.com

 

[KS]

Thank you for your suggestion. However, the MDE file has to be placed on the
server. Any other way to prevent the MDE file from overwritten?

 

[Douglas J. Steele]

Why does the MDE file have to be on the server? Hopefully you're not
intending to have all of your users share the same MDE file!

The proper way to have a multiuser application is to split the application
into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing the tables and relationships).
Only the back-end (which would be an MDB, since there's no point in making
an MDE for a table-only database) would be on the server. Each user should
have his/her own copy of the front-end (which usually would be an MDE),
ideally on his/her hard drive.

 

[Keith Wilby]

Thank you for your suggestion. However, the MDE file has to be placed on
the
server. Any other way to prevent the MDE file from overwritten?

Yes, make the folder Read-Only and have the users' shortcut point to a batch
file that downloads the mde to their local drive and then opens it. It's a
tried and tested method used by many experienced developers. Multi-users
sharing an mde file is a major no-no.

Keith.