Ninox vs access update#
Next step was the migrate our data another Database for our Marketing generation – We have over 600k records which is worked on daily to update info in many fields and these are crucial to getting new business. Keeping customer quotes/orders/supplier quotes/ acknowledgments on file with the jobs.Īutomating as much as possible ie Having the ability to auto remind clients of a product they purchased x months ago.Ĭross tracking completed jobs to our accounts system Invoices (need to automate this stage so need to link Ninox to Sage – so might invoice in sage and batch export to Sage ledger cards). Once this was done it was all about bolting on other tasks and enhancements. With Ninox the first step was to the get customer/supply files quotations/product file and all general aspects of the factory production stages into one system inc all email notifications (order acks/dispatch etc) and go paperless! Within 1 year. My Initial goal was to do away with our servers and get all our production / marketing into the cloud within 4 years. Solid month and found that I could get much more done in Ninox and in a fraction of the time! I finally settled on Access and Ninox to test thoroughly for. Coding for me is very much a hobby and became and essential much have to do exactly what I want as opposed to having something off the shelf that I have to bend our working to fit (my skill level is sort of intermediate). So given that I am very much a business man first and my primary task is to create/sell and generate a profit. (To be fair I absolutely love Excel ! Especially when VBA is employed!)
Useful as they are – I want a filed to hold data! In the end MS Access turned out to be too heavy weight and too slow to deploy also I did not want the complication of getting that into the cloud etc. MS Access (for me) falls in that I’m not interested in setting up loads of attributes to say a text field – ie shine/sunken field etc. But I did not like the current pricing scale for the amount of users I needed.
Ninox vs access software#
I like Filemaker as I own an early software set. Ie you still could not email through it without jumping through many hoops.
Ninox vs access windows#
The beauty of Dataease this that is RAD and essentially you design the form and the underlying table at the same time! Trouble was that as at 2020 despite being a windows platform and moving to a somewhat more event driven basis it was still well behind the likes of Filemaker and MS Access etc. Although multi user, it was very much procedural driven using a variation SQL.(DQL). My son works for Events at Games Workshop factory HQ in Nottingham - His favoutites is 40k and his paint list is in excel! He tried to teach me to play Bloodbowl the other day ! - Think I will stick to programming synths!īasically, my take on this was that all my production had been on Sapphires Dataease right from it’s DOS days back in early 1990’s and had grown up through the various upgrades. I'm impressed re the warhammer paint database shots.
Ninox vs access manual#
Also the support from the forum is great ! Sean/Stephen/John to name but a few! Ninox themselves have a few weaknesses Ie they are not currently active on the forum (shame) but prefer the join us on line zoom webinar type of approach and the lack of a decent tech manual does not help newbies! I think you might benefit from getting access to the EN2021 Ninox tech ref - Can't remember how you get access to this, but I think you just email support for this. Sure MS Access is awsome and powwerful, but to do it justice you need to read the access bible (I did twice!) and the build learning curve is huge compared to Ninox. What I like about Ninox it is that it essentially lets you focus on just getting on with the task you want to acheive and do as little or as much scripting as you want without having to worry about every minute attribute. Since then, it has all been about enhancements taking my system beyond what I had originally scoped for. Whereas in MS Access I had barely got past got past the tables/forms and a few tasks done. After several trials of other software - I set about creating my new system initially in both in MS Access (already had this) and Ninox - on the basis that both would need scripting to allow me to do the tasks that I wanted (ie VB in Access and JS(ish) in Ninox) Within 3 months I more or less had a complete fully working system in Ninox. That's a win in my book! and all before Covid brokeĪs my old system was no longer fit for purpose (Dataease 8). Saved a shed load of money and shared it with staff! (staff even happier). Staff now work from home (they are happy!), moved the factory to a smaller unit with less offices. After some 2 + years of working with Ninox- I am still learning, But I managed to bring forward my 4 year plan to run most of my business operation in the cloud.
0 kommentar(er)
