importing report from mde to mdb

[nemony]

This is our scenerio:

Our previous db person used both ends mdb and mde to make
changes, creating some reports, forms and so on so forth.

My problem now:

How can I import report/form from mde to mdb and vice-
versa. As you guess I can't make the changes from mdb and
run mde; because there are some reports on the mde end.

Thanks a lot

 

[Albert D. Kallal]

This is our scenerio:

Our previous db person used both ends mdb and mde to make
changes, creating some reports, forms and so on so forth.

My problem now:

How can I import report/form from mde to mdb and vice-
versa. As you guess I can't make the changes from mdb and
run mde; because there are some reports on the mde end.

You cannot modify or change the designs of the reports (or forms, or code)
etc. in a mde. So, the original person did NOT and could NOT have changed,
or made reports in the mde. All those reports are made in the mdb, and then
we you are done, you distribute the new mde to each user.

a mde is a runtime, user only file, and no design modifications can be made,
nor can any reports, screens, code etc. be extracted from the mde.

You must use the original mdb here.

 

[nynemo]

Hello Albert,

Thanks for your respond.

I guess, I didn't make myself clear in my original
message.

The current mde is different than current mdb; so, he
found a way to do it... The problem now, when I need to
make any changes or add some report, I have work on mdb
then run mde, right? However, I don't want loose some
stuff which are only in the mde. So, I can't run the mde.

I hope that's more clear.

 

[Douglas J. Steele]

The current mde is different than current mdb; so, he
found a way to do it...

There's no possibility that he found a way to do it. It's far more likely
that the MDB that corresponds to the MDE has been lost.

The problem now, when I need to
make any changes or add some report, I have work on mdb
then run mde, right? However, I don't want loose some
stuff which are only in the mde. So, I can't run the mde.

You'll have to try reengineering the changes in the MDE that aren't in the
MDB.

 

[nynemo]

How can I do that?

 

[Douglas J. Steele]

By rewriting all of the code from scratch.

 

[Andy]

Nemony;

I have imported tables from MDE files into MDB files and used and modified
them.

Open the MDB, Click on File, Click on Get external data, Click on Import
(I'm using Access 2K, Your steps may vary but the important thing is Click
on Import.)

Select the MDE file containing the Reports You want.

Click on the OK button.

Andy

 

['69 Camaro]

Hi, Andy.

Open the MDB, Click on File, Click on Get external data, Click on Import
(I'm using Access 2K, Your steps may vary but the important thing is Click
on Import.)

Select the MDE file containing the Reports You want.

One cannot import reports from an MDE database file or into an MDE database
file. Only the tables and queries can be imported using the built-in
wizards. If you think that you are succeeding in importing reports from the
MDE database file using the Import Wizard, then you are using an MDB
database file that has been renamed with the MDE extension, but it is still
an MDB database file.

Reports in an MDE database file can be copied into an MDB database file
(sans the module) or the report's design can be altered, but not by using
the Wizards.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)