I'm sorry, George, I've been doing some plumbing this weekend, so I can't really watch the entire video. I did watch some snippets, but if what I said in conjunction to what you said aligns with what's covered in the video then I'm afraid it's that trivial. No fancy stuff, just basic REST API. There's the NoSQL aspect to it, so I think other Access developers could give it a try anyway, given that it's gaining a lot of popularity.
Backend Access database on OneDrive - Can this be done (1 Viewer)
- Thread starter Snowflake68
- Start date
omar.aslaoui
New member
- Local time
- Today, 19:17
- Joined
- Mar 4, 2020
- Messages
- 5
What you want is a LAN that is simulated in a WAN (the internet). You can do that with Radmin VPN . You keep control of your data in a server in your LAN with rapid (fiber ?) connection to the internet, Radmin operate at 100MB/S . No need to change your access app. FE to the workstations (Local & remote) BE on a server with fast connection.
- Local time
- Today, 12:17
- Joined
- Feb 28, 2001
- Messages
- 30,891
The U.S. Navy set things up this way for our take-home laptops. While a VPN over a WAN does, in fact, work fairly well, it still suffers from the same problems that any WAN connection suffers. If the WAN connection drops long enough (and WAN connections CAN do that), the virtual connection also drops due to a time-out. It IS a game of probabilities. If a WAN were stable enough you wouldn't need a VPN. If the WAN is extremely unstable, the VPN won't remain connected. So I'm not saying it can't work... but caution is advised in any solution using a WAN.
GPGeorge
George Hepworth
- Local time
- Today, 10:17
- Joined
- Nov 25, 2004
- Messages
- 3,210
For those who regularly work with web APIs, it might seem trivial. That's kind of my point, though. If you have not used REST and APIs in a web environment, converting a department level application might not seem trivial at all. I agree it's worth exploring; I wouldn't put it on the same row as splitting an accdb and putting the back end on a LAN, at least not yet.
Is Firebase a NoSQL database?
Yeah, it's different from splitting an accdb and putting the BE on a LAN, which is extremely easy to do. But since such a simple method for web accessibility does not exist, alternatives must be used. I assume Microsoft's alternative is to make us migrate to Azure or their other products in exchange for a sum of money, but there are ways to avoid paying when the amount of data you use is <1GB. 1GB of data is considerably large, so most developers should be safe with that.
A "Firebase Realtime Database" is a NoSQL database. They also have other services, but the REST API used here is from the Realtime Database service. We have been using the term "Firebase" interchangeably here, but I have been referring to only that part of the service in particular.
amorosik
Active member
- Local time
- Today, 19:17
- Joined
- Apr 18, 2020
- Messages
- 665
It is very simple to answer this question
"No"
"As with ANY other programs you have on your servers that are running business right now"
It's very interesting. What do you know about which programs we are using?
Give me an example. Give me the name of one the programs we are using and may not be available the next year.
I will send your answer to our IT.
By the way, you missed the second part of that post where I explained the actual reasons I was given.
amorosik
Active member
- Local time
- Today, 19:17
- Joined
- Apr 18, 2020
- Messages
- 665
We can start with the operating system
And continue with all other programs
Whether you have a closed source operating system, whether you have an open source operating system, or whether you have specially trained personnel to provide adequate maintenance, there is no one who can guarantee that any problem can be 'repaired' ' quickly
What you can do are only two things:
- try to minimize problems in case a disastrous event could happ, with correct security policies
- take out an insurance policy that compensates for any damages caused by the problems that the system could generate
The real problem is that you are looking for a future 'guarantee' that a certain event cannot happen
And this thing there is no human being that can give it to you
What I meant initially is that the question asked "Can you GUARANTEE they are continuing this service next year too?" is a meaningless question
We have paid for the OS. We have Our DVDs. And as long as we decide to use it we CAN use it. It's not something to be ended or discontinued. The support may be ended, but as long as we decide, we are allowed to use it. And even if the life time of the OS is finished, it doesn't mean we are not allowed to use it. Or it doesn't work anymore. We are NOT left in a desert alone and all the company doesn't stop. We have enough time to change our platform (Which was another point given and you really missed it)
The life cycle of an OS only means we don't receive updates. Not we can't use it.
So it's GUARANTEED that the next year and the next one and another century or up to anytime to use our property.
You're talking about problems won't be repaired quickly. Which doesn't concern the sustainability of the service.
I really don't understand your logic and all other un-related points you're trying to tell me.
You can follow your rules, and I will follow our IT's decision. (Even if you think it's meaningless or stupid)
Let's drop the case here. We're hi-jacking the thread.
Thanks for your comment and My apologies to OP for going off road.
Last edited:
amorosik
Active member
- Local time
- Today, 19:17
- Joined
- Apr 18, 2020
- Messages
- 665
What ???
The only thing you can do is change the operating system to one that works correctly
If the manufacturer of that system decides you can't use it, there's really nothing you can do to keep using it
Whether you own your nice DVD or you paid to be able to use that operating system
"So it's GUARANTEED.." i'm sorry, but this is only your illusion
Last edited:
Similar threads
