Making an application from a DB

[sashabaz]

Hi again all,

I am trying (without success) to create an application/executable file from
a DB created in Access 2007. I used to do this in 2003 (using .mde) so that
the program ran as an application without the need for Access to be
installed. I have done some reading, and it seems that the new file type is
called .accde. However, when I click on the icon for this it tells me that I
have probably created a database that is too big (it goes into an explanation
of forms and the limit of 2048).

Im not sure how else to make the database run a) without having to have
Access installed; b) without the user having to open a specific form (i.e.
they ONLY see forms which have all the macros, etc.. needed for navigation).

Hope someone can help.... Ideally I would like to have the executable file
up and running....

 

[Arvin Meyer [MVP]]

Access requires (and always has) the Access executable to be installed. In
Access 2003 you may have made a runtime and installed that with your
application. That is also available to developers in Access 2007, but not it
is free. You can download it from Microsoft's website.

 

[hor vannara]

Hi again all,

I am trying (without success) to create an application/executable file
from
a DB created in Access 2007. I used to do this in 2003 (using .mde) so
that
the program ran as an application without the need for Access to be
installed. I have done some reading, and it seems that the new file type
is
called .accde. However, when I click on the icon for this it tells me
that I
have probably created a database that is too big (it goes into an
explanation
of forms and the limit of 2048).

Im not sure how else to make the database run a) without having to have
Access installed; b) without the user having to open a specific form (i.e.
they ONLY see forms which have all the macros, etc.. needed for
navigation).

Hope someone can help.... Ideally I would like to have the executable file
up and running....

 

[hor vannara]

Hi again all,

I am trying (without success) to create an application/executable file
from
a DB created in Access 2007. I used to do this in 2003 (using .mde) so
that
the program ran as an application without the need for Access to be
installed. I have done some reading, and it seems that the new file type
is
called .accde. However, when I click on the icon for this it tells me
that I
have probably created a database that is too big (it goes into an
explanation
of forms and the limit of 2048).

Im not sure how else to make the database run a) without having to have
Access installed; b) without the user having to open a specific form (i.e.
they ONLY see forms which have all the macros, etc.. needed for
navigation).

Hope someone can help.... Ideally I would like to have the executable file
up and running....

 

[John W. Vinson]

Hi again all,

I am trying (without success) to create an application/executable file from
a DB created in Access 2007. I used to do this in 2003 (using .mde) so that
the program ran as an application without the need for Access to be
installed.

Then you're the only person in the world who has ever done so. I think you're
mistaken; Access databases cannot be converted into executables and never have
been.

In 2003 (and earlier versions) it's very possible to create a .mde (now
..accde) compiled database, which turns off most design tools and hides any VBA
code. You can (independently) obtain the Access 2007 Runtime version, which
can be distributed to people who haven't installed full retail Access, and
which can be used to open and run Access databases (mdb, mde, accdb or accde).

I have done some reading, and it seems that the new file type is
called .accde. However, when I click on the icon for this it tells me that I
have probably created a database that is too big (it goes into an explanation
of forms and the limit of 2048).

That's a separate error. I certainly hope you still have the .accdb file from
which the .accde was created (that conversion is a one-way turnstile).

Im not sure how else to make the database run a) without having to have
Access installed; b) without the user having to open a specific form (i.e.
they ONLY see forms which have all the macros, etc.. needed for navigation).

You can have your own chosen form selected as the startup form.

Hope someone can help.... Ideally I would like to have the executable file
up and running....

Sorry, you can't; that option simply does not exist.