A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Version Updates



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 09:36 PM posted to microsoft.public.access.forms
ThickMike
external usenet poster
 
Posts: 9
Default Version Updates

I am writing an application in Access 2000 which travelling employees will
load onto their laptops. As they do not have the Access program loaded, they
will use Runtime.

I anticipate that revisions will be needed over time. Updates might be
changes to forms & macros, new forms & macros, data changes, extra fields in
tables (must not overwrite existing data)

The employees are not techie people and applying an update must be as easy
and straightforward as possible.

Is there a standard way of coping with Updates to the program?

Would I be better off splitting the database into front and back ends?

  #2  
Old May 28th, 2010, 04:36 AM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
 
Posts: 637
Default Version Updates

These people are they accessing the database over a network if so then
there should be no problem. If these people are each having a
different copy of the database then that sounds painful.

If the latter is what is happening then I would defiantly recommend
using a split database as updates may wreck data. Though saying that
you need to remember unless the file path where you save your dev back
end is the same as the path when they have their live back ends you
will experience problems.

As for the update process al they need to do is copy and overwrite the
file in the location where it was before.

Ie

C:\programfiles\mydatabase\mydatabasefront.mde
C:\programfiles\mydatabase\mydatabasebackend.mdb

They need to take the copy you send them and paste it there. So you
would email them a mydatabasefront.mde as for automating it you could
send them cds or usb flash drives and have a updateme app that copies
and pastes it automatically from there to the application path.

Though I have computer illiterate nurses working in my company that
can copy and paste from A to B even drag and drop they just need some
step by step instructions and a short lesson.

Hope this helps

Regards
Kelvan
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.