modify MDE

[Guest]

Hi,
I have an Access 2000 DB that was made into a MDE. I want to make changes
to the code of MDB file and again save it as a MDE. Can I retrieve the
tables from the first MDE so I can keep the existing data? I've tried "get
external data" but that didn't work.

Thanks,

 

[Rick Brandt]

Hi,
I have an Access 2000 DB that was made into a MDE. I want to make
changes to the code of MDB file and again save it as a MDE. Can I
retrieve the tables from the first MDE so I can keep the existing
data? I've tried "get external data" but that didn't work.

Thanks,

Normally you would have a split application (one file for tables only and
one for everything else) then you just replace the second file with a
modified one and your done.

In your case you should be able to delete all the tables in the modified MDB
and then import the tables from the MDE. File get external data - import
should work. What exactly "didn't work"?

 

[Guest]

Thanks Rick,
I was trying to import into my new MDE from the old MDE. If I click on
file/get external data/import, select a file to import from, select a table
and then click OK, it appears like something happens, but the data did not
import. Should this work? Is there a way to import from MDE to MDE?

Thanks

 

[Rick Brandt]

Thanks Rick,
I was trying to import into my new MDE from the old MDE. If I click
on file/get external data/import, select a file to import from,
select a table and then click OK, it appears like something happens,
but the data did not import. Should this work? Is there a way to
import from MDE to MDE?

Did you already have a table with the name of the table you are importing? If
so it will import as a new table with "1" added to the end of the name. It will
not just add the data to the existing table.

 

[Guest]

Thanks Rick,

From what you're saying, there is no way to update forms or reports in an
existing MDE db and retain the existing data without using the original MDB.
If so, that makes it difficult if you want to distribute runtime
applications. There are no magic tricks?????

Thanks,
Phil

 

[Rick Brandt]

Thanks Rick,

From what you're saying, there is no way to update forms or reports
in an existing MDE db and retain the existing data without using the
original MDB. If so, that makes it difficult if you want to
distribute runtime applications. There are no magic tricks?????

As stated previously, you split the app and updates are accomplished by
simply replacing the front end MDE with a new one. The Back End (or data
file) stays an MDB and in those situations where updates need to be applied
to that (new tables added for example) you can run code in the new front end
that makes the modifications to the back end file.