Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 4th, 2005, 05:44 PM
pdo pdo is offline
Registered User
Join Date: Apr 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Deployment tactics

Assume I deploy a run-time version of an Access Database to individual users who would enter data peculiar to themselves on their PC. It's really a single user DB linked to some code in Word.

Some time later, I need add/change a field within a table on that database. I would send an update to the various users.

Should I deploy this application as a front-end/back-end with MDE on the front-end and MDB on the back-end? Can I add a field to their back-end MDB without messing with their data? Is it wise to add some "spare" fields to the tables, and then only require code changes manipulating the 'spares' to the MDE front end that doesn't mess with the users data.

BTW, I know I can write code to manipulate the DB tables, copy data from the old tables to the new, etc. However, I would like to avoid that by being crafty ahead of time.


Similar Threads
Thread Thread Starter Forum Replies Last Post
deployment Bhavin Crystal Reports 1 February 5th, 2009 08:07 AM
deployment p2pMember ASP.NET 2.0 Basics 0 June 7th, 2007 01:12 AM
Deployment sen22 .NET Framework 2.0 1 April 17th, 2007 02:38 PM
Deployment regbnvl BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 0 May 7th, 2006 04:44 PM
Deployment Bhavin Crystal Reports 2 October 25th, 2004 08:28 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.