Storing files on line?

[Naz]

I'm working with 2 other people using calyx to run loan applications and other brokerage forms. The problem we are going to run into is if I have a applicants file on my computer then no one else can access/update it. They currently have pc anywhere hooked up to two of the computers. Computer one has the main file and when computer two wants to update they log onto computer one and update the file which stops that user from using their computer. Sounds like a pain when you throw computer three into the mix.
Is there any better, simple and secure way to have the main files in a central location where the three of us can access it but when one of us has a file open the other two can't open it.
I was thinking of mysql but I'm not really sure if that's what it's for.


Thanks,
Naz

[VHockey86]

You could setup an additonal PC and run a FTP server on it from the office connection or whereever. You wouldnt both be able to save to the file simultaniously... one person would have to save their changes and then the other person would have to download the new version in order to avoid overwriting it when they uploaded.
A simple solution, but im not sure how much better than what you are currently using
Im sure there are other, better, alternatives albeit perhaps more complicated/troublesome to setup

[Siliconjunkie]

A database does sound like the answer. It will handle the record/table locking for you so that users won't step on each other.

[filipino]

an idea of having a stand alone server using intranet and phpmysql or Coldfusion with MS Access Database. hmmm

Server:
Installed (Allaire Coldfusion 4.5) Optional Cost much but good
Installed (IIS with MS Access Database using ASP Technology)
Installed (Apache with PHPMYSQL combo)

client can use browser as the main incoding page to udate and to delete records (only data admin has access to delete or add record) to complicated when anyone can access the database.

its pretty hard to explain without blackboard but to make this thing short i suggest use Intranet Technolgy..

[Siliconjunkie]

Just use PHP to front MySQL. Its that simple.

I wouldn't bother with Coldfusion for cost reasons. Access has some real limitations. Start off doing it right rather than having to redo it down the road.

MySQL is plenty scalable if you have the hardware. I have a MySQL DB that is almost 1 TB, queries can be slow because of the nature of the data, but tolerable.

[filipino]

Originally Posted by Siliconjunkie

Just use PHP to front MySQL. Its that simple.

I wouldn't bother with Coldfusion for cost reasons. Access has some real limitations. Start off doing it right rather than having to redo it down the road.

MySQL is plenty scalable if you have the hardware. I have a MySQL DB that is almost 1 TB, queries can be slow because of the nature of the data, but tolerable.

yeah mysql not good for hudge amount of data can be slow when data contains about 450 MB .. but mysql is good cause its free ey just an idea oracle 9i is free now a days

the reason why i suggest coldfusion is because you can use any database you want with ease of use but your right about this thing cost too much why bother when you can find something for free