Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8
  1. #1
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts

    MS Access 2003 Database as exe file

    Good day!

    I created a database using MS Access 2003 and I want it make to MDE file but when I click the Make MDE File I got the pop up message like this:

    You cannot create a Microsoft Offiece Access ADE or MDe file from a
    database saved in Microsoft Office Access - 2000 format

    Convert the database to the current version of Microsoft Office Access. Then create the ADE or MDE File.

    When I check the Tools>Database Utilities>Convert Database>To Access 2000 File Format it was disable or grey out. I don't know why:confused:

    What should I do? or what configuration I need to do?

    Thank you

  • #2
    Regular Coder ajetrumpet's Avatar
    Join Date
    Jul 2009
    Location
    Iowa City, IA
    Posts
    407
    Thanks
    44
    Thanked 5 Times in 5 Posts
    its greyed out because the db is already in that format. choose another menu option sir.

    what version are you using? if you're using 2000 or less, you can't convert it obviously. you need 02-03 or newer.

  • #3
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by ajetrumpet View Post
    its greyed out because the db is already in that format. choose another menu option sir.

    what version are you using? if you're using 2000 or less, you can't convert it obviously. you need 02-03 or newer.
    I convert it already. now in my design view of my form I don't have picute in my properties, so I can put background image

    Thank you

  • #4
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts
    Is it possible that the switchboard could be executable? I want to happen be no need to open the ms access to view the forms. Only the switchboard form would be executed. I read some forums that I need the Microsoft Access Runtime and I'm not familiar with it.

    I already install Microsoft Acess Runtime and honestly I don't know what is the use of it

    Thank you

  • #5
    Regular Coder ajetrumpet's Avatar
    Join Date
    Jul 2009
    Location
    Iowa City, IA
    Posts
    407
    Thanks
    44
    Thanked 5 Times in 5 Posts
    Honestly, your language is not making much sense. the word "executable" refers to actual files and sometimes files located on servers.

    when you say "switchboard executable and the rest of the db not", that makes no sense at all. a switchboard is a form object in the database, nothing else. It cannot do anything special. it's just a form.

    The purpose of Access runtime is nothing more than to provide a "scaled-down" version of the database engine that oversees and runs the Access software program. It is really no different from the result you get from installing Access directly on your computer. The runtime software should be used for people that do not have access installed on their machines, or for people that do not have the correct version of access in order to run a distributed file that is of specific type (e.g. - running an .accde when ms access pre-2007 is installed). There is absolutely NO NEED to install it on your machine if your the developer. If you did, get rid of it because chances are, the installation itself has already made the runtime version the default program for opening your Access database files. This is extremely annoying and it also invites unexpected problems that are otherwise unknown to developers.

    IMO, the easiest way to distribute an access application is to use Access's ADE package. If you're running access version prior to 07, finding the package will pretty mcuh be impossible, and the 07 package might not even be available anymore. I have all of them saved on my machine as soon as they come out, because MS is notorious for dumping support of a previous software version THE DAY that the new one comes out to save every penny they can.

    files can also be distributed using an .MSI packager or .EXE packager, but some providers charge money to download them. by far, your best bet is to use an ADE package from microsoft because it's easy to use and free.
    Last edited by ajetrumpet; 11-04-2010 at 07:55 AM.

  • #6
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by ajetrumpet View Post
    Honestly, your language is not making much sense. the word "executable" refers to actual files and sometimes files located on servers.

    when you say "switchboard executable and the rest of the db not", that makes no sense at all. a switchboard is a form object in the database, nothing else. It cannot do anything special. it's just a form.

    The purpose of Access runtime is nothing more than to provide a "scaled-down" version of the database engine that oversees and runs the Access software program. It is really no different from the result you get from installing Access directly on your computer. The runtime software should be used for people that do not have access installed on their machines, or for people that do not have the correct version of access in order to run a distributed file that is of specific type (e.g. - running an .accde when ms access pre-2007 is installed). There is absolutely NO NEED to install it on your machine if your the developer. If you did, get rid of it because chances are, the installation itself has already made the runtime version the default program for opening your Access database files. This is extremely annoying and it also invites unexpected problems that are otherwise unknown to developers.

    IMO, the easiest way to distribute an access application is to use Access's ADE package. If you're running access version prior to 07, finding the package will pretty mcuh be impossible, and the 07 package might not even be available anymore. I have all of them saved on my machine as soon as they come out, because MS is notorious for dumping support of a previous software version THE DAY that the new one comes out to save every penny they can.

    files can also be distributed using an .MSI packager or .EXE packager, but some providers charge money to download them. by far, your best bet is to use an ADE package from microsoft because it's easy to use and free.
    Thank you...Is it impossible that my switchboard would become .exe so it is only the form should open no need to open the ms access

  • #7
    Regular Coder ajetrumpet's Avatar
    Join Date
    Jul 2009
    Location
    Iowa City, IA
    Posts
    407
    Thanks
    44
    Thanked 5 Times in 5 Posts
    Quote Originally Posted by newphpcoder View Post
    Thank you...Is it impossible that my switchboard would become .exe so it is only the form should open no need to open the ms access
    and once again, ".exe" has nothing to do with developing in Access. The way i'm reading it, you want your switchboard to appear such that it doesn't look like it's part of the Access program, yes?

    If that is so, yes that is possible, and it's called using a windows API function to hide the access program window. I even have the code necessary for it on my site. but, doing this is completely useless because it introduces more problems than it solves. If your stuck in a situation where someone using the database doesn't want to see the program window, OR if it is just your preference for development purposes, change your mode of thinking. I have been developing with this program for more than a decade and I can tell you with absolute certainty that developing in this type of manner never turns out well in the end, either for the user or for the developer.

    as far as displaying your form ONLY, and not other objects...if you're a developer, that's your job to make it happen. Nothing more to say about it.

  • #8
    New to the CF scene
    Join Date
    Feb 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    try converting the file from mdb to exe. This is the only way I guess you can easily create a MS Access ADE or MDE file from a database saved in Microsoft Office Access - 2000 or 2003 format. you can download a MDE Compiler here


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •