FE & BE Version Control Tips? - Microsoft Access / VBA

Tim Marshall

I usually develop major FE apps in my organization against a single
Oracle back end database. I'm now working on something different that
has a Jet BE and will have back ends all over the place. In fact, the
app is meant to be run on a single stand alone computer, ie, one FE only
against one BE (called a "data file" in my FE app), though there could
be many different BE ("data files") on a single PC. A user may switch
between BEs - I have this functionality working fine. The question mark
comes up when updates affect the structure of the BE.

I wondering what some folks do to "synch" their different versions. For
instance, we all know that requests for enhancements will be made, and
some of these may result in requiring table structural changes and even
additional tables on the BE. What I'm concerned about are people having
a later version of the FE with an earlier version of the BE and that
particular older BE might be lacking some fields/tables the newer FE
might be looking for.

Thanks very much in advance for any suggestions and/or advice in this area.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

Nov 13 '05 #1

Subscribe Reply

2554

Steve Jorgensen

On Tue, 06 Sep 2005 00:38:57 -0230, Tim Marshall
<TI****@PurpleP andaChasers.Moe rtherium> wrote:

I usually develop major FE apps in my organization against a single
Oracle back end database. I'm now working on something different that
has a Jet BE and will have back ends all over the place. In fact, the
app is meant to be run on a single stand alone computer, ie, one FE only
against one BE (called a "data file" in my FE app), though there could
be many different BE ("data files") on a single PC. A user may switch
between BEs - I have this functionality working fine. The question mark
comes up when updates affect the structure of the BE.

I wondering what some folks do to "synch" their different versions. For
instance, we all know that requests for enhancements will be made, and
some of these may result in requiring table structural changes and even
additional tables on the BE. What I'm concerned about are people having
a later version of the FE with an earlier version of the BE and that
particular older BE might be lacking some fields/tables the newer FE
might be looking for.

Thanks very much in advance for any suggestions and/or advice in this area.

The company I'm now working for uses the following approach.

- The back-end file includes a database version stored in a field in a table.
- When the front-end is about to link to the back-end, it first runs a series
of procedures, each of which is designed to upgrade a back-end structure from
one version to the next version.
- Each back-end update procedure performs its updates if the back-end version
is the same version it updates from, or does nothing if it is not.

So, a typical case might be a front-end that expects back-end version 4
opening a back-end at version 2. First, the 1-to-2 procedure sees that the
version is not currently "1" and does nothing. Next, the 2-to-3 procedure
sees that the version is "2", and upgrades it to "3". Next, the 3-to-4
upgrade procedure sees that the version is "3" (because it was just upgraded
to 3) and upgrades it to "4".

A possible problem is that you can't open a newer back-end with an older
front-end, so make sure all possible users upgrade their front-ends at the
same time.

Nov 13 '05 #2

Larry Linson

"Tim Marshall" wrote

. . . What I'm concerned about are
people having a later version of the
FE with an earlier version of the BE
and that particular older BE might be
lacking some fields/tables the newer FE
might be looking for.

There's an overview of "versioning " in the article at
http://accdevel.tripod.com/versioning.htm. Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm has a downloadable Front End Updater
that may be useful to you in distributing updates. I suspect the combination
is, at least, a start toward what you are doing.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #3

Tim Marshall

Tim Marshall wrote:

Thanks very much in advance for any suggestions and/or advice in this area.

Thanks Steve & Larry. I'll have to delve into the links Larry provided
and I've seen methods similar to what Steve has described in some of the
Oracle apps I manage.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Nov 13 '05 #4

Similar topics

28174

Image & PictureBox VB vs. VBA

by: Ed Landau | last post by:

In VB6.0, I can put an image on a form and assign it's .picture property at run-time. In VBA (within MS Access), when I put down an image control on a form, it asks me for the source to the image (at design-time). Why? Why can't I find PictureBox in VBA within MS Access? And most importantly...why can't I put either in a Report within MS Access? What I really want is to be able to display pictures in an MS Access report (pictures...

Microsoft Access / VBA

4936

Modal Form & Minimizing Access

by: Chris | last post by:

Modal forms are great for locking the user out of non focused forms allowing tight control over program flow, but they have one side effect which user find very irritating i.e. Access cannot be minimized. Perhaps I should be satisfied with the routine I have written which disables controls on a form before the popup form is opened but a background form full of disabled controls can look damned ugly in certain circumstances:-

Microsoft Access / VBA

2597

Themed Controls & Form Back Colour

by: Tim Marshall | last post by:

I would swear that when I developed in A97, I could change the back colour of a form. However, in Windows XP, on both A97 and A2003, there no longer is a property showing in the format tab for form properties for a back colour. I think the themed control idea is pretty good in that a developer can really go out on a limb if s/he chooses all kinds of fancy background colours for his/her app since colours selection is a very subjective...

Microsoft Access / VBA

1867

webparts & sqlclientpermission

by: António Pinho | last post by:

Hi, I have a big problem with an webpart/assembly. i'm trying to connect to sql server but i get the error "Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.". i've searched for it and can't find a clear answer. but one thing i'm sure: permissions. if i change the trust level in the web.config of the sharepoint portal...

ASP.NET

2578

REPOST: More Reference problems & custom controls disappearing

by: Suzanne | last post by:

Hi all, I'm reposting this message as I'm experiencing this problem more and more frequently : I really hope someone out there can help me as I've been tearing my hair out on this one for a good while and I'm getting really frustrated now! My problem is this - my custom controls periodically disappear from my

Visual Basic .NET

1712

ASP.Net controls & AJAX

by: Sharon | last post by:

Hi all, I was wondering if anyone had experience using ajax with asp.net controls. What i'm looking for, are ways to implement and possible problems. A way to implement could be rendering the control on the server side, and send the html string back to javascript. A possible problem is the control post back behavior and control view state usage. Thanks, Sharon.

ASP.NET

2436

When to use Public/Private Key & when to gen new one?

by: Sky | last post by:

Hello: I'm trying to make sense of snk files, when to use, under what conditions to regenerate new ones,...can someone take a look if these statemes make sense? And then the final questions at the end that they first statements bring up in my mind... a) Because two developers, unbeknownst to each other, can end up releaseing different dll's with the same name, one should sign an assembly with a unique tag. right?

C# / C Sharp

1737

Which version of Access for images

by: anthony | last post by:

I am going to have to start holding jpg files (about 6,000 - 10,000 a year) in our school database. Mainly, they will end up being printed as part of the children's profiles ie via a report. I understand that Access 2007 can hold images without the associated bloat created by previous versions. However, I am reasonably used to Access 2003 and would only want to upgrade if there were significant advantages in the way Access 2007 handles...

Microsoft Access / VBA

8825

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7327

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4152

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4304

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General