kanazky said:

does Sage require the file to be local?

If you have a VPN it should work, but latency may make the setup impractical.  There's a lot of data communication that happens in small chunks, so any latency has a dramatic effect on performance - even multiple switches / routers on a LAN slows things down noticeably. 

kanazky said:

use a remote server for their Sage Accounting to allow Multiple Users access to the same Sage Database at the same time.

(Edited )

The Sage Connection Manager opens up a new data port as each connection is made.  10 users = 10 additional ports.  for each company:

Better to use RDP or something similar (where 20,000 SQL requests for one report aren't going through multiple ISP's equipment, one at a time). 

kanazky said:

I see create a new company and chose Quantum as the type, however I don't see an option for a network located database file.

There isn't an option, because there is no difference whatever.  Local data is still client-server.  If the 'company file' (actually a file + the mySQL data folder) is on a local drive to the client, data requests are looped back to the local (MySQL) data server.  

If the file is created locally it can be copied to any location that can be accessed from Windows Explorer.  (with SMB, not FTP.  

kanazky said:

does Sage require the file to be local?

If you have a VPN it should work, but latency may make the setup impractical.  There's a lot of data communication that happens in small chunks, so any latency has a dramatic effect on performance - even multiple switches / routers on a LAN slows things down noticeably. 

kanazky said:

use a remote server for their Sage Accounting to allow Multiple Users access to the same Sage Database at the same time.

(Edited )

The Sage Connection Manager opens up a new data port as each connection is made.  10 users = 10 additional ports.  for each company:

Better to use RDP or something similar (where 20,000 SQL requests for one report aren't going through multiple ISP's equipment, one at a time). 

kanazky said:

I see create a new company and chose Quantum as the type, however I don't see an option for a network located database file.

There isn't an option, because there is no difference whatever.  Local data is still client-server.  If the 'company file' (actually a file + the mySQL data folder) is on a local drive to the client, data requests are looped back to the local (MySQL) data server.  

If the file is created locally it can be copied to any location that can be accessed from Windows Explorer.  (with SMB, not FTP.  

RandyW said:

The Sage Connection Manager opens up a new data port as each connection is made.  10 users = 10 additional ports.

Randy, sorry to question this but are you referring to ports 13540, 13541 etc?  If so, a new connection/user connecting to the same open database does not open a new port, it uses the same one.  A port like 13540 is only opened for a specific company datafile.  The next file opened will typically get 13541.  This is a generality and doesn't always happen in this order but the concept is accurate.