Updating project/db

  • Thread starter Thread starter Mike J
  • Start date Start date
M

Mike J

Is there an easy way to update the project at a "customer"
site with the newly updatedn project I worked on at my sit?
IE. My customer has the db but there were a few bugs that
I fixed on my computer. The only way I update it now is
cut and paste the forms which is cumbersome.
 
"Mike J" wrote
Is there an easy way to update
the project at a "customer"
site with the newly updatedn
project I worked on at my sit?
IE. My customer has the db but
there were a few bugs that
I fixed on my computer. The
only way I update it now is
cut and paste the forms which
is cumbersome.
Click to expand...

Did you split the database into back-end (tables, data, and relationships)
and front-end (queries, forms, reports, macros, modules, and any needed
local look-up tables)? If so, then simply provide the complete new front-end
to the users to replace their old one.

If you did not, you'll never be able to do this sooner than now, and that is
when you should do it.

What form of database did you provide the client? MDB, MDE, ADP, ADE? If you
gave the client "compiled" MDE that included the tables/data, then you'll
need to retrieve their data into a separate MDB before you proceed. ADP/ADE,
by definition, do not include the data and you should be able to replace the
whole front-end; MDB can be split from the data... you'll have to extract
the client's data, first, then provide a new MDB which you link to the
backend data tables.

Larry Linson
Microsoft Access MVP
 
-----Original Message-----
"Mike J" wrote


Did you split the database into back-end (tables, data, and relationships)
and front-end (queries, forms, reports, macros, modules, and any needed
local look-up tables)? If so, then simply provide the complete new front-end
to the users to replace their old one.

If you did not, you'll never be able to do this sooner than now, and that is
when you should do it.

What form of database did you provide the client? MDB, MDE, ADP, ADE? If you
gave the client "compiled" MDE that included the tables/data, then you'll
need to retrieve their data into a separate MDB before you proceed. ADP/ADE,
by definition, do not include the data and you should be able to replace the
whole front-end; MDB can be split from the data... you'll have to extract
the client's data, first, then provide a new MDB which you link to the
backend data tables.

Larry Linson
Microsoft Access MVP


.
Thanks for the feedback. It's .mdb and where do I find
Click to expand...
out how to seprate the two? How do I access the
tables/data if they are seperated?
 
Back
Top