move backend to server

[Sammie]

I am moving my backend to a server with SBS 2003. What is the best way to
configure the database on the server and on each client? I need remote
access to the back end.

Should I store the front-end database on each client, or should I put it on
the server? If I put it on the server, do I need a front-end copy for each
user or can they share the same one?

For remote access, should I install Access on the server? Should a front
end copy reside on the server?

 

[tedmi]

It is safest to have a copy of the FE on each client, if you expect
simultaneous use of your db from users on multiple clients.
The FE and Access need not be installed on the server, unless you want
someone to use the application locally on the server - not a good idea.
Not sure what you mean by "remote access" - over a LAN, or via internet?

 

[Sammie]

Thanks.
I need remote access over the internet. I have access on my laptop. How do
I connect to the back end on the server?