Cannot make mde ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
Click to expand...

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]
 
Back
Top