Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Updating Programs in Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Richards - 12 Mar 2006 09:48 GMT
I am developing a system for some clients. They currently have version 1
of the system and are building up the data om the databases. When I have
developed version 2 how can I install this on their PC without
overwriting the data they have accumulated?

What I need to do is update forms, queries, reports etc but leave the
base data unchanged.

Thanks
Albert D.Kallal - 12 Mar 2006 11:01 GMT
You should have split you database.

I explain in detail here why you do this

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

If you split the database, then I even offer a "web" update button in my
application. here is some screen shots that show this

http://www.kallal.ca/ridestutorial/upgrade.html

I simply execute a followhyper link to my web site..and they can then update
the software anytime they need to....

in  your case, simply send them a new front end, and have it link to the
existing non-split back end (this means your existing application will
become the back end...and you simply send them a new front end without the
data....

Signature

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Paul Richards - 13 Mar 2006 06:33 GMT
Albert: what if I haven't split the database?

> You should have split you database.
>
[quoted text clipped - 14 lines]
> become the back end...and you simply send them a new front end without the
> data....
Albert D.Kallal - 13 Mar 2006 14:51 GMT
> Albert: what if I haven't split the database?

Simply split your copy...and then, I shall re-post what I suggested...

quote ---

>> in  your case, simply send them a new front end, and have it link to the
>> existing non-split back end (this means your existing application will
>> become the back end...and you simply send them a new front end without
>> the data....

end quote ---

Signature

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Paul Richards - 13 Mar 2006 19:41 GMT
What’s wrong with using replication to create a Design Master?

>>Albert: what if I haven't split the database?
>
[quoted text clipped - 8 lines]
>
> end quote ---
George Nicholson - 13 Mar 2006 20:59 GMT
Replication is really only intended for synchronizing *data* changes. It
doesn't handle significant form & report changes all that well. (It isn't
all that crazy about heavy changes to table structure either, if I remember
correctly, but that may have been just my experience).

In any case, you would still have a similar issue: your design master would
need to have been set up *before* it was distributed and data added by the
client.

HTH,
Signature

George Nicholson

Remove 'Junk' from return address.

> What’s wrong with using replication to create a Design Master?
>
[quoted text clipped - 10 lines]
>>
>> end quote ---
Albert D.Kallal - 14 Mar 2006 04:33 GMT
> What’s wrong with using replication to create a Design Master?

because the client already have a operational application deployed on site.
The user is looking for a way to send them a new updated appcation, but not
touch the data part. So, simply creating a new front end that will link to
the existing data file makes sense. The fact that the original appcation is
not split really don't matter, since you can send a new front end that will
link to their existing data file.

With replication, all kinds of new setup, and data files will have to be
created, and THEN placed on the clients computer, and further, to set that
up, either you have to travel to the clients location, or have the client
send you THEIR data while you setup replication. And, further, replication
assumes that you have some type of connection, which one may, or may not
have. Really, quite a complex process as compared to simply emailing a
client a new zipped mde file....

Further, as noted, replication is for replication of data, and trying to use
it for replication of software updates to an application is a disaster at
best, and at worst will not work for a mde file.....

Signature

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Paul Richards - 14 Mar 2006 06:59 GMT
So the best bet is to create an Access project with separate data and
application parts as you suggest?

>>What’s wrong with using replication to create a Design Master?
>
[quoted text clipped - 16 lines]
> it for replication of software updates to an application is a disaster at
> best, and at worst will not work for a mde file.....
DrZilboorg - 14 Mar 2006 15:53 GMT
Best bet???

I'm just getting my arms around this stuff, but from what was presented, it's
the only bet if you aren't in the disaster recovery business.

I'll be splitting the DB I'm working on, and I don't plan on distributing it
anywhere. But I might be networking the business that I'm building it for at
some point in the future, and it makes sense to do it.
John Nurick - 14 Mar 2006 20:38 GMT
Doesn't have to be an ADP if that's what you had in mind; but yes, split
the data store and the front end.

>So the best bet is to create an Access project with separate data and
>application parts as you suggest?
[quoted text clipped - 19 lines]
>> it for replication of software updates to an application is a disaster at
>> best, and at worst will not work for a mde file.....

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.