Automate MDB to MDE Conversion

[chathag]

I have over 30 databases that must be sent to external users on a daily basis. The databases must be sent as MDE files. The current process is to manually convert them. Is it possible to automate this task using VBA? A point in the right direction would be appreciated.

Regards

C

 

[DCrake]

Are they 30 different mdbs or the same one to all 30?

if the latter then make the first and copy the rest.

David

 

[chathag]

Each db is different as the data it contains is specific to each user.

 

[DCrake]

Does the mdb you are sending contain both the frontend and the back end data?

If this does then in reality they should already have their own copy of the front end and you send them the back end data periodically. The user then simply overwrites the previous submission and views the data. If you code the front end so that each location can only look at their data then the same mdb can be distributed without the need to keep making mde's

David