TransferDatabase in MDE

T

Tony_VBACoder

In an Access 2002 MDE, is there a way to Export out a
Table or Report to a brand new MDB database? When I use
the TransferDatabase command, I get an error telling me I
cannot export objects from an MDE. However, if I keep the
database as a MDB, I am able to export my Report and Table
out to a new MDB.
 
A

Alex Dybenko

i think you can export a table from MDE (at least you can import from it
into other database), but report - you can't
 
T

Tony_VBACoder

Yup...you are correct. I was able to export just my table
from my MDE, but not my Report.

Is there no way to export a Report from an MDE to a new
MDB?
 
C

Chris Nebinger

As the report could have code behind it, and the code is
stripped away and only saved as compiled code, I doubt you
could.


Chris Nebinger
 
A

Alex Dybenko

agree, this is by design

Alex


Chris Nebinger said:
As the report could have code behind it, and the code is
stripped away and only saved as compiled code, I doubt you
could.


Chris Nebinger
Click to expand...
 
T

Tim Ferguson

agree, this is by design
Click to expand...

But it's probably fairly easy to recreate the report in another mdb and
base it on a query based on linked tabledefs from the original file.

Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export BPMN Visio Chart to Excel 0
Exporting Outlook 2007 contact list without losing groups 0
Locks using TransferDatabase 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
VBA concatenate ranges into a new document 0
Slow MDE Performance with MSAccess 2007 1
Datasourcemoniker issue with .mde file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top