The most common cause of being unable to create an MDE file, is syntax
errors in the database. Use the Debug : Compile All option (or whatever
that is called in your version of Access) to recompile all the VBA code
in your database. You will probably find there is a syntax error. Fix
the error & repeat until there is no error. Then try the MDE again.
Another rare but possible cause of being unable to create an MDE, is
using methods of the dbengine object without explicitly using the
dbengine qualifier; for example:
opendatabase(..) instead of DBENGINE.opendatabase(..)
Re: MDE not possible ? ...First compile the MDB and make sure that there are no errors in the code ... before creating the MDE.... Because of the methode used to compile the database a lot of references ... If your database is in Access 2000 file format (it should say on ... (microsoft.public.access.formscoding)
Re: Acces VBA Password ... > the product, the Make MDE file selection is not enabled on the Tools, ... Web page to help you determine why you can't create the MDE database:... version of the VBA source code, even if there's a VBA password placed on the ... (microsoft.public.access.security)
Re: MDE not possible ? ... I converted my frontend MDB to the Access 2002-2003 format and tried to ... I get an error that the MDE couldn't be created. ... This error occurse mostly while compiling big databases to a MDE file. ... Because of the methode used to compile the database a lot of references will ... (microsoft.public.access.formscoding)
Re: Mailmerge from MDE not working ... I tried this Ian and when I try to nominate the database that I want the ... >create a mail merge against the MDE file "by hand" ie. from within Word ... >>OpenDataSource method to send its data from a query within Access as part ... (comp.databases.ms-access)
Re: Help - Shared MDE - Exclusive Access message box ... I have a MS Access 2003 database having 3 files: ... The shortcut points to MDE file and includes /wrkgrp for the MDW ... Each user should have a copy of the frontend MDE on their local workstation. ... would put all the users in a group that has administer permissions in the ... (microsoft.public.access.security)
