MS Access 2003 Database as exe file

[newphpcoder]

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

[ajetrumpet]

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.

[newphpcoder]

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

[newphpcoder]

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

[ajetrumpet]

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.

[newphpcoder]

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

[ajetrumpet]

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.

[kbWizard]

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 (http://www.mdecompiler.com/) a MDE Compiler here