How do I replace or update a major file once I have finalized myAccess designs?

[BC]

I have been working with an old copy of a file while I have been
designing my Access application. While I am doing this, the Major data
file is being updated/modified by other means (another application
called paradox). Access can import a paradox.db file, but I am
concerned about messing up things if I delete the old one and import a
new one. Do I have a big problem here?

 

[Cheryl Fischer]

You shouldn't have really big problems if you have documented any possible
changes you made to the table structure of the first file you imported for
use in Access. If you did any data cleanup after this table was imported,
you should have saved the queries that you used to do that. Try renaming
the table that you are currently working on and then importing the most
current Pdox table, apply your structure and data cleanup changes and then
compare the current table with the old one.

hth,

 

[John Vinson]

I have been working with an old copy of a file while I have been
designing my Access application. While I am doing this, the Major data
file is being updated/modified by other means (another application
called paradox). Access can import a paradox.db file, but I am
concerned about messing up things if I delete the old one and import a
new one. Do I have a big problem here?

Have the other developers been changing the *structure* of this table
- adding, changing, or deleting fields? Or just the data, the
contents?

If the latter, and if you've been reasonably careful in your design,
you should have no difficulties. If they've been changing the table
design, you will of course need to reflect those changes in all the
Queries, Forms, Reports and so on which reference the table.

In my experience, Paradox tables often require a bit of tweaking when
you import them into Access. Access is rather more "relational" than
Paradox, and Paradox tables often contain calculated expressions
and/or table lookups, which are better handled in Access by creating
Queries based on the "core" fields of the table.