Realtime website updating.

[M-G]

I know it can be done but I'm just not sure even where to begin. The idea is that there is a local library here that needs to update their website from their local db. My only solution so far is to ftp a file to the server where the php reads it and inserts info to the web db for display on the site. How would I go about getting this done automatically?
Thanks for your help

**edit**
And securly...so as to not expose the local pc to web threats.

[redsox9]

What type of database does the library use to store information? Is it a MySQL database? You could create an interface that allows approved users to add, edit, or delete information from the database using php scripts.

[M-G]

They are using microsoft access

[redsox9]

Is there an online interface that has already been created?