Make Mde Front end

[Presten via AccessMonster.com]

I'm new to mde. The previous coder made a mde front end with a backend of
tables. Now I have to put a drop-down on one of the forms. I have the clean
version of the mdb. I added the drop-down to the form and added the table
change to the backend table.

But now, it's taking toooooo long to make the mde. Its not responding.
Tried to compile the code, but the "compile" is not enabled.

Can anyone help me, please. I need to move the change to production.

Thanks,
Presten

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200805/1

[Salad]

Re: Make Mde Front end

Presten via AccessMonster.c om wrote:

I'm new to mde. The previous coder made a mde front end with a backend of
tables. Now I have to put a drop-down on one of the forms. I have the clean
version of the mdb. I added the drop-down to the form and added the table
change to the backend table.
>
But now, it's taking toooooo long to make the mde. Its not responding.
Tried to compile the code, but the "compile" is not enabled.
>
Can anyone help me, please. I need to move the change to production.
>
Thanks,
Presten
>

Open your desktop icon to open the app and add
/decompile
to the end of it.

Once the app is opened, get to the database window then compact it then
compile it.

Once complete, remove the /decompile from the icon.

Hard Sun

http://www.youtube.com/watch?v=nZbiZxA9b5k

[Presten via AccessMonster.com]

Re: Make Mde Front end

Sorry, I'm not getting it. tried to put a / at the end, but it will not take
this character. Are you saying to rename it? Where do I place the /?

Salad wrote:

>I'm new to mde. The previous coder made a mde front end with a backend of
>tables. Now I have to put a drop-down on one of the forms. I have the clean

>[quoted text clipped - 8 lines]

>Thanks,
>Presten

>
>Open your desktop icon to open the app and add
> /decompile
>to the end of it.
>
>Once the app is opened, get to the database window then compact it then
>compile it.
>
>Once complete, remove the /decompile from the icon.
>
>Hard Sun
>http://www.youtube.com/watch?v=nZbiZxA9b5k

--
Message posted via http://www.accessmonster.com

[Salad]

Re: Make Mde Front end

Presten via AccessMonster.c om wrote:

Sorry, I'm not getting it. tried to put a / at the end, but it will not take
this character. Are you saying to rename it? Where do I place the /?

You don't have a Windows desktop icon to call the application? If you
don't, why not create one? I had to shorten down the command line for
one of mine so it wouldn't wordwrap and confuse you but it looks
something like this

"C:\Program Files\msaccess. exe" "C:\App\Appname .mdb" /decompile

BTW, the reason the Compile button may have been disabled is that the
MDB may have been compiled and if you made no changes to the code
there'd be nothing to compile.

Making an MDE isn't instantaneous either. It copies and pastes and
compiles and compacts and encrypts itself so you do have to wait. I
don't know how long it takes you but if it's taking an inordinate amount
of time I'd decompile, the compact and recompile it prior to making the MDE.

Wonders Never Cease

http://www.youtube.com/watch?v=yViHGA_AJmk

>
Salad wrote:
>

>>>I'm new to mde. The previous coder made a mde front end with a backend of
>>>tables. Now I have to put a drop-down on one of the forms. I have the clean

>>
>>[quoted text clipped - 8 lines]
>>

>>>Thanks,
>>>Presten

>>
>>Open your desktop icon to open the app and add
>> /decompile
>>to the end of it.
>>
>>Once the app is opened, get to the database window then compact it then
>>compile it.
>>
>>Once complete, remove the /decompile from the icon.
>>
>>Hard Sun
>>http://www.youtube.com/watch?v=nZbiZxA9b5k

>
>

[Albert D. Kallal]

Re: Make Mde Front end

"Presten via AccessMonster.c om" <u7122@uwewro te in message
news:843f300324 01c@uwe...

Tried to compile the code, but the "compile" is not enabled.
>

Just hit ctrl-g, and in the code editor add a blank line some where (just
hit enter).

now, do a debug-compile....

If the code compiles, then you should be able to create the mde. (make sure
no forms or code is open and running).

The time to create a mde should be about 5-10 seconds max.....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa llal@msn.com

[rkc]

Re: Make Mde Front end

Presten via AccessMonster.c om wrote:

I'm new to mde. The previous coder made a mde front end with a backend of
tables. Now I have to put a drop-down on one of the forms. I have the clean
version of the mdb. I added the drop-down to the form and added the table
change to the backend table.
>
But now, it's taking toooooo long to make the mde. Its not responding.
Tried to compile the code, but the "compile" is not enabled.
>
Can anyone help me, please. I need to move the change to production.

I believe you also have to make sure that the .mdb file is saved in
the format of the version of Access you are using. In other words, if
you are using 2002 but have saved in 2000 format the make mde option
will not be available until you convert to 2002 format.