reconvert exe back to access design

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ken - 25 Feb 2008 17:18 GMT

i have distributed my first attempt at an exe version of access database. it
installs fine and the user now has issues after he has entered a considerable
amount of data. to troublshoot while saving the data, can he send me the
access runtime application, and how/ can i open this in design mode to
troublshoot as well as retrieve the data inputted?

thanks you

Reply to this Message

John W. Vinson - 25 Feb 2008 18:30 GMT

>i have distributed my first attempt at an exe version of access database.

Then you've done something no Access developer I know has ever been able to
do! Access does not provide the ability to produce an .exe file. Do you
perhaps mean a .mde file?

>it installs fine and the user now has issues after he has entered a considerable
>amount of data. to troublshoot while saving the data, can he send me the
>access runtime application, and how/ can i open this in design mode to
>troublshoot as well as retrieve the data inputted?

You can't, basically

See http://www.granite.ab.ca/access/createmdbfrommde.htm. If you didn't keep
the original mdb file, it's very difficult to get it back.

In addition, if it's a multiuser system, it should certainly be split. Take a
look on Tony's website for discussion of split applications.

Signature

John W. Vinson [MVP]

Reply to this Message

ken - 25 Feb 2008 19:36 GMT

funny...yes. it is an .mde. now, that i have been a fool of, i hope you can
provide the answer.
thks

> >i have distributed my first attempt at an exe version of access database.
>
[quoted text clipped - 14 lines]
> In addition, if it's a multiuser system, it should certainly be split. Take a
> look on Tony's website for discussion of split applications.

Reply to this Message

John W. Vinson - 25 Feb 2008 21:48 GMT

>funny...yes. it is an .mde. now, that i have been a fool of, i hope you can
>provide the answer.
>thks

Apologies if you felt I was making a fool of you... I was answering the
question as posted.

Did you look at Tony's website? It explains that you generally cannot convert
a .mde back to a .mdb file (because the VBA source code has been removed), and
provides a link to a site (in Poland, and I believe in the Polish language)
for a utility which claims to be able to reconstruct the .mdb from the .mde. I
have not tried this utility myself but I understand that it can work, though
the recovered code may not be identical to the original (for instance, any
comments in the code are lost forever).

Signature

John W. Vinson [MVP]

Reply to this Message

ken - 25 Feb 2008 23:52 GMT

many thanks. i was just joking above. once again, mny thks for help

> >funny...yes. it is an .mde. now, that i have been a fool of, i hope you can
> >provide the answer.
[quoted text clipped - 10 lines]
> the recovered code may not be identical to the original (for instance, any
> comments in the code are lost forever).

Reply to this Message

Tony Toews [MVP] - 26 Feb 2008 07:00 GMT

>i have distributed my first attempt at an exe version of access database. it
>installs fine and the user now has issues after he has entered a considerable
>amount of data. to troublshoot while saving the data, can he send me the
>access runtime application, and how/ can i open this in design mode to
>troublshoot as well as retrieve the data inputted?

Presumably you still have the MDB so you can change the forms, reports
and VBA code. Even though it's an MDE you can still work with the
tables, queries and macros. So you can import the tables and
relationships into a new MDB. Then split your MDB into a FE & BE and
relink to the users data MDB.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Reply to this Message