Long Distance Networking

[Eddie Mason]

I would like to have a back-end Database on a host server and link a
front-end Database to the tables several hundred miles away. The problem is I have no experience whatsoever in doing this.

My questions are:

(1) Can tables be linked via the Internet?

(2) If they can, is this the best way to link the tables?

(3) If it is possible to link the tables by the internet or by some other way; how do I do it?

I really would appreciate any help you can give.

Kind regards

Eddie

 

[Geoff Convery]

I wouldn't touch it with a bargepole, Eddie, unless you're using a web front end about which I know nothing. The only way I know to share a database over a Wide Area Network without it being in danger of corrupting it is to upsize to SQL Server but you'll need a computer running SQL Server to act as the server so there's a cost involved.