mde file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please Help?
Why are the tables and queries still accessible and editable in my MDE file?
 
Because an MDE only protects VBA code. You can also edit Macros in an MDE.

From the Help file:

Saving your database as an MDE file prevents the following actions:

- Viewing, modifying, or creating forms, reports, or modules in Design view.
- Adding, deleting, or changing references to object libraries or databases.
- Changing code using the properties or methods of the Microsoft Access or
VBA Object models -- an MDE file contains no source code.
- Changing your database's VBA project name using the Options dialog box.
- Importing or exporting forms, reports, or modules. However, tables,
queries, and macros can be imported from or exported to non-MDE databases.
Any tables, queries, or macros in an MDE database can be imported into
another database, but no forms, reports, or modules can be imported into
another database.
 
Thanks very much.

I also have another question. I have a multiuser database and every so
often I am getting a "Write Conflict" Error Message. What is really causing
it and how can I fix it. Its giving me 3 options "Drop Changes" "Save
Changes" and Copy to ClipBoard" to analyse. I believe that save and drop
changes options will affect either me or the other user and the "Copy to
ClipBoard" option does not work it says I" You dont have that privellage" But
I am logged as "Admin:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 and MDE file Question 10
Save command disabled in MDE 1
Access 2007 and MDE Files 1
SHift Key disable (again..) 3
Access 2007 and MDE 1
mde file 2
Can't make MDE 3
Unable to create MDE File 3

Back
Top