MS Access data conversion - Access Runtime - Reinstall Compiled Project with Data

Author

Access Runtime - Reinstall Compiled Project with Data

melickas@yahoo.com

2005-12-06, 11:25 am

I am starting over explaining a problem we have - please disregard
previous posts as they are misleading.

We designed a VBA Application using Office 97 Developer Tools. We
distributed this as an ACCESS RUNTIME application. The database was
split into MDE & MDB, we ran the ODE Setup Wizard to create
installation floppies. The customer added data to the application.

If relavant, our customer has a new computer running XP Pro.

On the new computer, how do we reinstall the application we created (we
have the original floppies) and import their data?

Tools we have:

1. Office Developer 97 ODE Tools
2. Office Developer XP ODE Tools
3. We have the original MDB we created, before it was split and run
through the 97 Setup Wizard.
4. We have there current backend MDB with the data in the tables.

Thank you!

Chris Mills

2005-12-06, 1:24 pm

Why not create a new installation on the new computer from your install
floppies, then just overcopy the backend mdb with the customer's backend file
containing the data?

Chris

<melickas@yahoo.com> wrote in message
news:1133887776.069387.33710@g49g2000cwa.googlegroups.com...
> I am starting over explaining a problem we have - please disregard
> previous posts as they are misleading.
>
> We designed a VBA Application using Office 97 Developer Tools. We
> distributed this as an ACCESS RUNTIME application. The database was
> split into MDE & MDB, we ran the ODE Setup Wizard to create
> installation floppies. The customer added data to the application.
>
> If relavant, our customer has a new computer running XP Pro.
>
> On the new computer, how do we reinstall the application we created (we
> have the original floppies) and import their data?
>
> Tools we have:
>
> 1. Office Developer 97 ODE Tools
> 2. Office Developer XP ODE Tools
> 3. We have the original MDB we created, before it was split and run
> through the 97 Setup Wizard.
> 4. We have there current backend MDB with the data in the tables.
>
> Thank you!
>

Albert D.Kallal

2005-12-14, 3:25 am

> On the new computer, how do we reinstall the application we created (we
> have the original floppies) and import their data?

As the other poster mentioned, why not just use those floppies..and install
the appcation? It should run on the new box....

After you use the floppies to install..then you would simply copy the data
part that you saved over the one that the install created
(this assumes a split database...so..you would just copy over the back end
mdb file.

There is essentially no need to convert this appcation to a later version of
ms-access. and, there is essentially no need to use the xp developer
tools..as the old 97 appcation should continue to just work fine.

As far as I can tell...you don't have to do anything..but install the
application..and copy your mdb data file from the old machine to the new
one...

Perhaps your question might be how you would convert this to the xp version
of ms-access, but that is not what you are asking.and you made no reason, or
hint as to why you need to convert the application to access xp.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@
msn.com
http://www.members.shaw.ca/AlbertKallal

Sponsored Links