unable to create an MDE database

[Guest]

I'm trying to build a release version of a database, but I keep getting
"Microsoft Access was unable to create an MDE database". I got this to work
when the database was a bit smaller (12 Mb; now it is 20 Mb after conversion
to Access 2003 format), but now I'm stuck.

The very limited Help mentions a TableID limit of 2048. I have 11 tables, 10
queries, 8 forms, and 2 modules. The biggest table has 51,668 rows.

Can anyone tell me what I'm up against?

Thanks!

 

[John W. Vinson]

I'm trying to build a release version of a database, but I keep getting
"Microsoft Access was unable to create an MDE database". I got this to work
when the database was a bit smaller (12 Mb; now it is 20 Mb after conversion
to Access 2003 format), but now I'm stuck.

The very limited Help mentions a TableID limit of 2048. I have 11 tables, 10
queries, 8 forms, and 2 modules. The biggest table has 51,668 rows.

Can anyone tell me what I'm up against?

The most likely cause is that the database is in A2000 format (which is
actually the default for new databases in A2002/2003). Just using an A2000
database in A2003 does not convert it. If so you need to convert it to 2002/3
format prior to making a MDE.

Another possibility is that there is a compilation error in the database's VBA
code. Type Ctrl-G to open the VBA editor and select Debug... Compile <your
database name>. If there are any compilation errors, fix them, compile again,
close VBA, compact and repair the database, and try making a MDE once more.

The size of your database shouldn't be a factor - it's quite modest.

John W. Vinson [MVP]

 

[Guest]

Aha!

I found some advice to compile the code and found a bad API reference. I
deleted an unnecessary module, and everything is now OK.