creating an MDE in access 2003

J

Jerry

i receive "Microsoft Office Access was unable to create
an MDE database". Can someone help me with this?
 
N

Nikos Yannacopoulos

Jerry,

I know of two possible reasons for this, (a) a very large number of objects,
resulting in a total of temporary objects during conversion which is more
than Access can handle in that process (about 2K, I think, but I might be
wrong), or (b) errors in the code.
Statistically, (b) is a lot more common that (a), so I would suggest you
start looking there. Open the VB editor and from the menu go Debug >
Compile. Any coding error will be highlighted. Fix and repeat until
compilation goes through without errors, then try to make the .mde again.
Chances are you won't have to worry about (a) above.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top