Error Unable to create an MDE

[kenneth]

Greetings:

I get the error MS Accesss was unable to create an MDE
database with a front end access application. All the
tables are linked to the back end the app runs in access.
What should I check for?

Kennneth
DBA

 

[Nikos Yannacopoulos]

Kenneth,

The most common reasons for this are two:
(a) Too many objects
(b) Error(s) in VB code

For (a) to be the case, your FE should have several hundred objects (I've
seen varying numbers, but the least I think was 500 or so). Not very common
relatively to (b), being the most common reason. To check for (b), open any
module in design view, and go to menu Debug > Compile [your database name]
now. If there is a coding error it will be highlighted. Fix and repeat until
the process finds no more errors, and chances are it will solve your
problem.

HTH,
Nikos

 

[Guest]

Please disregard I removed a module and it ran.

 

[Guest]

Hi Nikos,

this is really the porblem of (b), i faced this problem
and tried so so so hard for cause and solution. Until i
saw your tips on (b), and that is really the cause of
problem. Thanks and you are my savior.

Junny

-----Original Message-----
Kenneth,

The most common reasons for this are two:
(a) Too many objects
(b) Error(s) in VB code

For (a) to be the case, your FE should have several hundred objects (I've
seen varying numbers, but the least I think was 500 or so). Not very common
relatively to (b), being the most common reason. To check for (b), open any
module in design view, and go to menu Debug > Compile [your database name]
now. If there is a coding error it will be highlighted. Fix and repeat until
the process finds no more errors, and chances are it will solve your
problem.

HTH,
Nikos

Greetings:

I get the error MS Accesss was unable to create an MDE
database with a front end access application. All the
tables are linked to the back end the app runs in access.
What should I check for?

Kennneth
DBA

.