VBA, Create MDE with Access 97 / 2002 problem

Create MDE with Access 97 / 2002 problem

Author	Message
Hans-Christian Franck #1 / 7	Create MDE with Access 97 / 2002 problem I have installed both Access 2002 and 97 on my maschine and try to make an MDE out of the MDB. This fails with the error message "Compile error in hidden module" and with a referance to a form in the MDB. The MDB is compiled with no compile errors before attempting to make the MDE. When I try to make an MDE out of a smaller MDB there is no errors. Making the MDE from the same MDB succeedes on another machine with just Access 97 installed. Thanks for any clues that can help me out. -- Kind regards Hans-Christian Francke www.master-office.com
Mon, 30 May 2005 21:37:17 GMT

michk #2 / 7	Create MDE with Access 97 / 2002 problem Are you using DAO at all? One common cause of this is using top level DAO objects without prepending the DBEngine to them.... -- MichKa This posting is provided "AS IS" with no warranties, and confers no rights. Quote: > I have installed both Access 2002 and 97 on my maschine and try to make an > MDE out of the MDB. > This fails with the error message "Compile error in hidden module" and with > a referance to a form in the MDB. > The MDB is compiled with no compile errors before attempting to make the > MDE. > When I try to make an MDE out of a smaller MDB there is no errors. > Making the MDE from the same MDB succeedes on another machine with just > Access 97 installed. > Thanks for any clues that can help me out. > -- > Kind regards > Hans-Christian Francke > www.master-office.com
Mon, 30 May 2005 23:44:31 GMT

Stephen K. Youn #3 / 7	Create MDE with Access 97 / 2002 problem MichKa helped me with this once a long time ago. To be specific, you need to add the DbEngine prefix for common operations such as: DBEngine.OpenDatabase(strDbPath) DBEngine.Idle dbRefreshCache DBEngine.CreateDatabase The Mdb may work without the prefix, but fail to compile to .Mde. You might also have some code corruption, in which case you might want to try decompile. See: http://www.trigeminal.com/usenet/usenet004.asp?1033 - Steve Are you using DAO at all? One common cause of this is using top level DAO objects without prepending the DBEngine to them.... -- MichKa This posting is provided "AS IS" with no warranties, and confers no rights. Quote: > I have installed both Access 2002 and 97 on my maschine and try to make an > MDE out of the MDB. > This fails with the error message "Compile error in hidden module" and with > a referance to a form in the MDB. > The MDB is compiled with no compile errors before attempting to make the > MDE. > When I try to make an MDE out of a smaller MDB there is no errors. > Making the MDE from the same MDB succeedes on another machine with just > Access 97 installed. > Thanks for any clues that can help me out. > -- > Kind regards > Hans-Christian Francke > www.master-office.com
Tue, 31 May 2005 01:07:51 GMT

Hans-Christian Franck #4 / 7	Create MDE with Access 97 / 2002 problem Is this the case for Acc 97 as well. I use Acc 97 to make the MDE. -- Kind regards Hans-Christian Francke www.master-office.com Quote: > Are you using DAO at all? One common cause of this is using top level DAO > objects without prepending the DBEngine to them.... > -- > MichKa > This posting is provided "AS IS" with > no warranties, and confers no rights. > > I have installed both Access 2002 and 97 on my maschine and try to make an > > MDE out of the MDB. > > This fails with the error message "Compile error in hidden module" and > with > > a referance to a form in the MDB. > > The MDB is compiled with no compile errors before attempting to make the > > MDE. > > When I try to make an MDE out of a smaller MDB there is no errors. > > Making the MDE from the same MDB succeedes on another machine with just > > Access 97 installed. > > Thanks for any clues that can help me out. > > -- > > Kind regards > > Hans-Christian Francke > > www.master-office.com
Tue, 31 May 2005 15:07:08 GMT

michk #5 / 7	Create MDE with Access 97 / 2002 problem Yes, it is actually much more commonly a problem in in Access 97. -- MichKa This posting is provided "AS IS" with no warranties, and confers no rights. Quote: > Is this the case for Acc 97 as well. I use Acc 97 to make the MDE. > -- > Kind regards > Hans-Christian Francke > www.master-office.com > > Are you using DAO at all? One common cause of this is using top level DAO > > objects without prepending the DBEngine to them.... > > -- > > MichKa > > This posting is provided "AS IS" with > > no warranties, and confers no rights. > > > I have installed both Access 2002 and 97 on my maschine and try to make > an > > > MDE out of the MDB. > > > This fails with the error message "Compile error in hidden module" and > > with > > > a referance to a form in the MDB. > > > The MDB is compiled with no compile errors before attempting to make the > > > MDE. > > > When I try to make an MDE out of a smaller MDB there is no errors. > > > Making the MDE from the same MDB succeedes on another machine with just > > > Access 97 installed. > > > Thanks for any clues that can help me out. > > > -- > > > Kind regards > > > Hans-Christian Francke > > > www.master-office.com
Tue, 31 May 2005 21:46:27 GMT

Hans-Christian Franck #6 / 7	Create MDE with Access 97 / 2002 problem I tried to prepend DBEngine to DAO objects but the error persist. Shouls I also prepend Application to DBEngine and Strings to the Left function and so on or is this a specific problem related to DAO objects. -- Kind regards Hans-Christian Francke www.master-office.com Quote: > Yes, it is actually much more commonly a problem in in Access 97. > -- > MichKa > This posting is provided "AS IS" with > no warranties, and confers no rights. > > Is this the case for Acc 97 as well. I use Acc 97 to make the MDE. > > -- > > Kind regards > > Hans-Christian Francke > > www.master-office.com > > > Are you using DAO at all? One common cause of this is using top level > DAO > > > objects without prepending the DBEngine to them.... > > > -- > > > MichKa > > > This posting is provided "AS IS" with > > > no warranties, and confers no rights. > > > > I have installed both Access 2002 and 97 on my maschine and try to > make > > an > > > > MDE out of the MDB. > > > > This fails with the error message "Compile error in hidden module" and > > > with > > > > a referance to a form in the MDB. > > > > The MDB is compiled with no compile errors before attempting to make > the > > > > MDE. > > > > When I try to make an MDE out of a smaller MDB there is no errors. > > > > Making the MDE from the same MDB succeedes on another machine with > just > > > > Access 97 installed. > > > > Thanks for any clues that can help me out. > > > > -- > > > > Kind regards > > > > Hans-Christian Francke > > > > www.master-office.com
Tue, 31 May 2005 22:31:18 GMT

Hans-Christian Franck #7 / 7	Create MDE with Access 97 / 2002 problem OK! problem was solved when prepending DBEngine to all DAO objects. Thanks. -- Kind regards Hans-Christian Francke www.master-office.com Quote: > Yes, it is actually much more commonly a problem in in Access 97. > -- > MichKa > This posting is provided "AS IS" with > no warranties, and confers no rights. > > Is this the case for Acc 97 as well. I use Acc 97 to make the MDE. > > -- > > Kind regards > > Hans-Christian Francke > > www.master-office.com > > > Are you using DAO at all? One common cause of this is using top level > DAO > > > objects without prepending the DBEngine to them.... > > > -- > > > MichKa > > > This posting is provided "AS IS" with > > > no warranties, and confers no rights. > > > > I have installed both Access 2002 and 97 on my maschine and try to > make > > an > > > > MDE out of the MDB. > > > > This fails with the error message "Compile error in hidden module" and > > > with > > > > a referance to a form in the MDB. > > > > The MDB is compiled with no compile errors before attempting to make > the > > > > MDE. > > > > When I try to make an MDE out of a smaller MDB there is no errors. > > > > Making the MDE from the same MDB succeedes on another machine with > just > > > > Access 97 installed. > > > > Thanks for any clues that can help me out. > > > > -- > > > > Kind regards > > > > Hans-Christian Francke > > > > www.master-office.com
Tue, 31 May 2005 23:13:43 GMT

Page 1 of 1

[ 7 post ]