How to organize a network in this situation?

Question

VPN

There is a base in Firebird on a stationary computer, there is a router (with wi-fi) to which the Internet is connected with a static IP. It is necessary to organize client access to the database, about 8 machines, 4 of which are in the same room as the computer with the database itself, the rest are remote clients.
Is this option possible: connect the Internet to a computer with a base, connect a router through the second LAN board and organize a LAN via wi-fi for those computers that are in the same room. On a computer with a base, raise a VPN (for example, openVPN).
On Windows machines. Is this possible or is there a more elegant solution?

Answer 1

It was very "convenient" to write from a tablet ...
Is it possible in this situation to simultaneously connect via VPN to the database?

Answer 2

I'm sorry, the question seems wrong to you.
What is your position in this organization?

Answer 3

tight, very tight. .what "wi-fi router"? is there any budget?

Answer 4

a beautiful solution is to put a piece of iron with VPN support at the entrance to the local network, that is, instead of the TL-WR741ND. It is possible to change the same TL-WR741ND with WRT firmware and raise openvpn, but I'm afraid it will not pull 4 users. By the way - you also need to imagine what speed should be for the application. There are many railroad options.
firebird to expose outside portmapping - I would think well.