Replication of mde files possible?

[giedrius]

Hello,

I was wondering is it really possible to replicate an mde file? I am comparing replication versus front-end/back-end database implementation technology. I tried to replicate an mde file, but with no success. If this is not possible at all, how can I make sure, that my code is not accessible to an odd user?

Thanks,
giedrius

 

[ghudson]

A MDE db is compiled and the code is not accessable for viewing/editing/exporting, etc. Your code will be safe in a MDE version of your db [ensure that you keep the original MDB copy in a safe place because you can not edit the design of a MDE db. I am sure that somebody out there has a MDE decompiler yet it would be very expensive to purchase "if" there is one available. Visual Basic or Access do not have a built-in decompiler for Access MDE applications.

 

[giedrius]

I think you have misinterpreted my question - I may have been not precisely clear. I was asking about data base replication ( compilation or decompilation are actually different topics in this sense). I was wondering if it is possible to make a replica of a database file if it is compiled into an mde file.

giedrius

 

[Keith P]

Use fe/be and replicate the b/e. Issue a new f/e when there have been changes.

 

[giedrius]

After some experimenting I came to the conclusion that mde files can not be replicated, however the following technology can be implemented:

Make b/e as Design Master file and create a replica thereof. Then in f/e (which is mde file) make links either to the Design master or to the replica as needed. Works fine!

Hope this can be useful to other people if they ever come to this problem.

giedrius