I have built a large database for distribution on a network. I would like to
distribute the database as an ACCDE file. However, when I try to convert the
database I get an error message saying the file was not converted. I have
split the database to make it smaller and it still will not work. Do I have
any options here?

On Fri, 2 Jan 2009 05:14:00 -0800, KC1960
<(E-Mail Removed)> wrote:

"an error message": can you be more specific?

-Tom.
Microsoft Access MVP


>I have built a large database for distribution on a network. I would like to
>distribute the database as an ACCDE file. However, when I try to convert the
>database I get an error message saying the file was not converted. I have
>split the database to make it smaller and it still will not work. Do I have
>any options here?

Did the file start out as an older version of access?
If so I would try creating a new database in 2007 and importing all the
elements of the old file. Fix your references, relationships and try saving
as ACCDE.

"KC1960" <(E-Mail Removed)> wrote in message
news:9CBC71F5-D490-4F9E-93B8-(E-Mail Removed)...
>I have built a large database for distribution on a network. I would like
>to
> distribute the database as an ACCDE file. However, when I try to convert
> the
> database I get an error message saying the file was not converted. I have
> split the database to make it smaller and it still will not work. Do I
> have
> any options here?

The message I get says "Microsoft Office Access was unable to create the
..accde, .mde, or .ade filr. When I click the help button it says this error
is usually associated with compiling a large database into an MDE file.

"Tom van Stiphout" wrote:

> On Fri, 2 Jan 2009 05:14:00 -0800, KC1960
> <(E-Mail Removed)> wrote:
>
> "an error message": can you be more specific?
>
> -Tom.
> Microsoft Access MVP
>
>
> >I have built a large database for distribution on a network. I would like to
> >distribute the database as an ACCDE file. However, when I try to convert the
> >database I get an error message saying the file was not converted. I have
> >split the database to make it smaller and it still will not work. Do I have
> >any options here?
>

KC1960 <(E-Mail Removed)> wrote:

>The message I get says "Microsoft Office Access was unable to create the
>.accde, .mde, or .ade filr. When I click the help button it says this error
>is usually associated with compiling a large database into an MDE file.

That is usually a misleading message. Approximately how many of each
type of object do you have in your accdb?

Have you tried compiling the code?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/