MDE File Permission

  • Thread starter Thread starter KS
  • Start date Start date
K

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?
 
KS said:
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
 
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?
 
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.
 
KS said:
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.
 
Back
Top