Cannot make mde ???

[Guest]

Hi,

I have a very small .mdb currently holding 3 tables and no more than 11
records. When I try to make an .mde file, I get an error stating that the
..mde cannot be created due to it's large size.

Anyone please?

Thanks,
Jenn

 

[Guest]

What is the size of your mdb after compact?
any way you should seperate between your application to your data, create
two mdb, one hold your table and the second holds your application: forms,
reports, queries, macros, functions.
link the tables to your application mdb, and then create a mde, you dont
need to create a mde to your data mdb.
It is easier to maintain your application like that, so the next time you
upgrade your application you dont have to worry about your data.

 

[John Vinson]

Hi,

I have a very small .mdb currently holding 3 tables and no more than 11
records. When I try to make an .mde file, I get an error stating that the
.mde cannot be created due to it's large size.

What's the *exact* error message (it may be an erroneous error!), the
Access version, and the size in KBytes of the .mdb file? Have you
tried Tools... Database Utilities... Compact and Repair, and does this
affect anything?

John W. Vinson[MVP]