Deploying Access Databases

  • Thread starter Thread starter Majman33
  • Start date Start date
M

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!!
 
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.
 
Majman33 said:
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!!
Click to expand...

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
 
Back
Top