"Make MDE File" Ghosted

[Jeffrey_Chcgo]

I converted an Access 97 database to Access 2002. I then wanted to create an
MDE from this database. But under Tools\Database Utilities the "Make MDE
File" option is ghosted. What is wrong here?

Thanks.

 

[Paul Overway]

If the file is 2000 format, you can't make an MDE. It needs to be in 2002
format...or you need to compile using Access 2000.

 

[Jeffrey_Chcgo]

Thanks for your response. I also just found the answer on Microsoft's
knowledge base.

 

[Jeffrey_Chcgo]

I tried to convert the 2002 formatted database to an MDE and got the error "
Microsoft Access was unable to create an MDE database." Microsoft's
knowledgebase states that the error is caused by "The Microsoft Jet database
engine version 4.0 allows a maximum of 2048 open TableIDs at one time". I
don't get this. The database I am trying to convert does not have any
tables, reports, forms, modules that I can do without. And I don't think
this database is that overly complicated or large. Why should there be such
a limitation? is there any way to get around this? Do I have to split the
database first?

Thanks again.

 

[TC]

You probably just have a compilation error in your database. Just use
the "compile all" option (not sure where that is on your version of
Access) & it will show you where the error is. Fix the error, then try
again.

Another very obscure (but possible) cause of not being able to create
an MDE, is having VBA code that references methods of the DBEngine
object without explicitly providing the DBEngine qualifier. If you
don't understand what that means, then, it probably is not the cause of
your error.

HTH,
TC