Hi Ricardo,
A .mde file is made so people can't change anything anymore. The code is never viewable anymore.
I would suggest you to split your database. By keeping all the tables in a secure back end the data keeps the same. It's very simple if you follow the wizard. The following link provides you with more info on the subject
http://office.microsoft.com/en-us/ac...010342026.aspx
Afterwards, to get to the question, I solve this problem by doing this:
I create a table in the backend, called "Tbl_LatestVersion" and a table in the .mde frontend called "Tbl_Version".
-
Public Sub CheckVersionAndPath()
-
If DLookup("Version", "Tbl_Version") = DLookup("LatestVersion", "Tbl_LatestVersion") Then
-
Exit Sub
-
Else
-
MsgBox "The version of the front-end currently in use is out of date. Please update to a newer version.", vbCritical Or vbOKOnly, "Old version!"
-
DoCmd.Quit
-
End Sub
-
The code above runs every time the database is opened and checks whether or not the latest version of the frontend (.mde) is being used.
This way people can use the .mde and you can change the things you want in your .mdb.
If you are done changing, you change the values in both tables and create a new .mde.
This way the old .mde becomes unusable and so you can be sure that everyone is using the latest version.
Please note that this solution is far from perfect!!
If I am being unclear, let me know and I'll be more detailed when I have got more time.
Jens