Remotely accessable database

[marleyuk]

Ive got a medium sized database that i use to keep a record of customer details and services i provide made in access. Id like to make this a server and be able to remotely connect to it from other locations.

Any ideas on where i can start?

Thanks,
Ian.

 

[shadow9449]

I've had a lot of success deploying Access databases using Windows Terminal Service. You don't need to change anything about your database and if it's designed well, you should be able to get a decent number of users at the same time. It really depends on what your needs are and how many users will be accessing the database a the same time.

SHADOW

 

[marleyuk]

I only need a couple of users at anyone time. Possibly 2. I want it to be as easy to setup as it can be.

 

[marleyuk]

Yeah but as i cant really use SQL, anyone help with access?

 

[marleyuk]

I was hoping there was a cheeky script that i may have been able to use. Like paste a bit of script that would make it remotely accessable? or do i have no chance?