Multiple users using access at the same time

[yepwingtim]

How can I do this with an ftp server?
I want to upload the mdb file to the ftp server where multiple users (3-4 people) can access it at the same time.

Thanks guys
________
Honey oil

 

[georgedwilkinson]

Very risky proposal.

Forget the ftp part (it sends shivers up my spine). Put it on a normal file server on a LAN, split it, and give the users the front end. You'll have real problems hitting and Access database over a WAN or, even worse over the Internet.

An option might be to use terminal services (logmein.com, gotomypc.com, Citrix, MS Terminal Service, etc.) to allow users to access the front end remotely.

 

[yepwingtim]

Hi thanks for your reply George.
I have to this do over the internet =(
We have 4 different locations...

Is there anyway to get around this?
________
Teen health advice

 

[georgedwilkinson]

You can try using a VPN but be prepared for data corruption.

The best "remote" solution is either terminal services or a web application.

 

[yepwingtim]

Web Applications meaning html -> php -> odbc

Is there any tutorial for this...
________
VAPIR NO2 VAPORIZER

 

[georgedwilkinson]

Web Applications meaning html -> php -> odbc

Is there any tutorial for this...

PHP, JSP, ASP, C#, .Net, etc.

I learned to do it partially by years of work in Java and C++. It's something that I wouldn't even attempt if you don't already have some of the skills.

PHP is quite popular and the barriers to entry are fewer than with the other approaches.

 

[georgedwilkinson]

BTW, the cost to re-develop as a web application is much more expensive than implementing terminal services.

 

[yepwingtim]

Ahh thanks George... I guess this won't be possible for me. Thanks for the input though.
________
Medical marijuana