Deploying Access Databases

[Majman33]

Hi all. I created a database for my dad's business.
Naturally, after deploying it for him, they have run into
a few bugs. My problem is that I did not split the
database before deploying it and now I cannot figure out
how to make the necessary changes without overwriting the
entire database when I intall the new version. Please
help!!

 

[Paul Overway]

You'll have to ask him to send it back to you at a time when he won't be
entering any data. Then split it and send it back. Then you can make
changes to the front end file without affecting his data.

 

[Arvin Meyer]

Hi all. I created a database for my dad's business.
Naturally, after deploying it for him, they have run into
a few bugs. My problem is that I did not split the
database before deploying it and now I cannot figure out
how to make the necessary changes without overwriting the
entire database when I intall the new version. Please
help!!

Make a copy of the database and delete all the tables. When you have
completed the fixes, you can link the data tables left on his machine to
your newly corrected from end. After you are sure everything is working OK,
then delete the forms, queries, reports, and code, out of the old database
that still has the current data. Make sure to build copies when you are
making any changes, so you can revert, if necessary. Also compact the
database several times after deleting the objects.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access