Home

MS Access continuous delivery

%3CLINGO-SUB%20id%3D%22lingo-sub-552253%22%20slang%3D%22en-US%22%3EMS%20Access%20continuous%20delivery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552253%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20any%20way%20to%20manage%20continuous%20delivery%20with%20MS%20access%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethansk%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-552253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699770%22%20slang%3D%22en-US%22%3ERE%3A%20MS%20Access%20continuous%20delivery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699770%22%20slang%3D%22en-US%22%3EPlease%20be%20more%20specific%2C%20what%20are%20you%20delivering%3F%20Give%20us%20more%20context.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699803%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20MS%20Access%20continuous%20delivery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699803%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20reply%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10231%22%20target%3D%22_blank%22%3E%40Juan%20Soto%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%3CP%3EWe%20are%20building%20application%20for%20many%20customer%20in%20MS%20Access.%3C%2FP%3E%3CP%3EAfter%20first%20release%20customer%20will%20start%20using%20it%20and%20input%20some%20date.%3C%2FP%3E%3CP%3EWhen%20we%20will%20have%20ready%20second%20release%2C%20how%20can%20we%20deploy%20it%20to%20customers%20not%20to%20loose%20there%20data%20that%20they%20had%20already%20entered%20in%20first%20release.%3C%2FP%3E%3CP%3ESo%2C%20my%20question%20is%20what%20is%20best%20practice%20for%20MS%20Access%20with%20continuous%20delivery%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-728465%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20MS%20Access%20continuous%20delivery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-728465%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%20maybe%20you%20need%20to%20become%20familiar%20with%20%22MS%20Access%20Linked%20Table%20Manager%22%20and%2C%20perhaps%20%22MS%20Access%20runtime.%22%26nbsp%3B%20You%20should%20easily%20be%20able%20to%20%22continuously%20deliver%22%20once%20you%20figure%20just%20a%20couple%20things%20out%2C%20i.e.%2C%20how%20to%20deploy.%26nbsp%3B%20Multiple%20options%20most%20with%20minimal%20or%20zero%20code.%26nbsp%3B%20It%20does%20require%20research%2C%20investigation%20and%20testing%20for%20your%20specific%2C%20optimal%20solution.%26nbsp%3B%20No%20doubt%20consider%20splitting%20your%20solution%20into%20two%20(2)%20files%20a%3A%201.)%20front-end%3B%20and%2C%202.)%20back-end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339100%22%20target%3D%22_blank%22%3E%40iesartia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773138%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Access%20continuous%20delivery%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339100%22%20target%3D%22_blank%22%3E%40iesartia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20more%20solutions%20for%20this%2C%20I%20will%20tell%20you%20mine%3C%2FP%3E%3CP%3E.%3C%2FP%3E%3CP%3EAs%20mentioned%20it%20is%20wise%20to%20split%20database%20and%20frontend.%20Access%20provides%20a%20function%20for%20this.%3C%2FP%3E%3CP%3EFor%20updates%20you%20are%20stuck%20with%20the%20old%20database%20because%20the%20customer%20is%20using%20the%20data%20and%20adds%20and%20updates%20it%20a%20lot.%3C%2FP%3E%3CP%3EYou%20can%20write%20a%20procedure%26nbsp%3B%20(or%20let%20it%20be%20writen%20for%20you)%20what%20is%20checking%20if%20the%20frontend%20is%20new%2C%20makes%20a%20backup%20of%20the%20current%20database%20containing%20the%20data%2C%20alters%20the%20tables%20as%20desired%20in%20the%20current%20database%20based%20on%20a%20database%20you%20provide%2Finclude%20with%20the%20update%2C%20updates%20values%20as%20needed%20and%20add%20records%20to%20tables%20what%20you%20need%20(for%20example%20settings%20stored%20in%20tables).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20same%20goes%20for%20the%20reports%2C%20forms%2C%20modules%20etc.%20You%20can%20even%20design%20it%20that%20it%20will%20remains%20safe.%20So%20the%20end%20product%20is%20a%20executable%20database%20compiled%20so%20nobody%20steels%20your%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20I%20do%20it%20for%20my%20projects%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
iesartia
New Contributor

Hi All,

 

is there any way to manage continuous delivery with MS access?

 

thansk

4 Replies
Please be more specific, what are you delivering? Give us more context.

Thanks for your reply @Juan Soto .

We are building application for many customer in MS Access.

After first release customer will start using it and input some date.

When we will have ready second release, how can we deploy it to customers not to loose there data that they had already entered in first release.

So, my question is what is best practice for MS Access with continuous delivery?

Greetings ...

 

It sounds like maybe you need to become familiar with "MS Access Linked Table Manager" and, perhaps "MS Access runtime."  You should easily be able to "continuously deliver" once you figure just a couple things out, i.e., how to deploy.  Multiple options most with minimal or zero code.  It does require research, investigation and testing for your specific, optimal solution.  No doubt consider splitting your solution into two (2) files a: 1.) front-end; and, 2.) back-end.

 

 

@iesartia 

@iesartia 

 

There are more solutions for this, I will tell you mine

.

As mentioned it is wise to split database and frontend. Access provides a function for this.

For updates you are stuck with the old database because the customer is using the data and adds and updates it a lot.

You can write a procedure  (or let it be writen for you) what is checking if the frontend is new, makes a backup of the current database containing the data, alters the tables as desired in the current database based on a database you provide/include with the update, updates values as needed and add records to tables what you need (for example settings stored in tables).

 

The same goes for the reports, forms, modules etc. You can even design it that it will remains safe. So the end product is a executable database compiled so nobody steels your code.

 

This is how I do it for my projects:)

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies