I have developed an application starting in 97 and upgraded to 2002. It has
about 30 forms, 200 tables, 200 querries and about 10 VBA modules. I can
create an MDE with Access 2002. I can open the program with Access 2003. It
opens and runs. When I try to create an MDE it says it has a problem with its
size and the number of table ID's and can't do it. Taking the same program
back to Access 2002 it won't compile there either. I need to solve the
problem by either making the 2002 program work with the new Jet macro
security or getting a certificate in it in 2003 and creating an MDE. Any help
would ge greatly appreciated.

See whether there's anything in
http://www.access.qbuilt.com/html/co...#CannotMakeMDE that helps.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Late Night Coder" <(E-Mail Removed)> wrote in
message news:421FAAD5-8409-4B56-81D4-(E-Mail Removed)...
>I have developed an application starting in 97 and upgraded to 2002. It has
> about 30 forms, 200 tables, 200 querries and about 10 VBA modules. I can
> create an MDE with Access 2002. I can open the program with Access 2003.
> It
> opens and runs. When I try to create an MDE it says it has a problem with
> its
> size and the number of table ID's and can't do it. Taking the same program
> back to Access 2002 it won't compile there either. I need to solve the
> problem by either making the 2002 program work with the new Jet macro
> security or getting a certificate in it in 2003 and creating an MDE. Any
> help
> would ge greatly appreciated.

Most probably yoy will have to convert the database to ms access 2003 format.

"Douglas J. Steele" wrote:

> See whether there's anything in
> http://www.access.qbuilt.com/html/co...#CannotMakeMDE that helps.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Late Night Coder" <(E-Mail Removed)> wrote in
> message news:421FAAD5-8409-4B56-81D4-(E-Mail Removed)...
> >I have developed an application starting in 97 and upgraded to 2002. It has
> > about 30 forms, 200 tables, 200 querries and about 10 VBA modules. I can
> > create an MDE with Access 2002. I can open the program with Access 2003.
> > It
> > opens and runs. When I try to create an MDE it says it has a problem with
> > its
> > size and the number of table ID's and can't do it. Taking the same program
> > back to Access 2002 it won't compile there either. I need to solve the
> > problem by either making the 2002 program work with the new Jet macro
> > security or getting a certificate in it in 2003 and creating an MDE. Any
> > help
> > would ge greatly appreciated.
>
>
>