Update of Access DB client side

[papa_kilo]

Running Apache 2.0.35, PHP 4.2.0 MS Access 2000. User is allowed to select (via checkboxes) records from a server side Access DB then update their DB. I'm having difficulty comprehending this one - am also a novice at PHP. I've been told to upload each rec one at a time but I would prefer to have user select the necessary recs for update and then send all at once.
The questions:
1. How do I locate the client side db for update? I assume I ask the user to identify the db using <INPUT TYPE="file"...> and using the source as the destination.
2. If I am going to download to the client, do I store each rec in an array then use SQL "INSERT INTO..."
I've hit a mental block
HELP!

[sarahk]

Locating the file should be easy - look for any file upload script.

Updating a client side mdb file might be harder but look for some of the code for ole automation with word. Access should follow similar rules.

I'd be inclined to display the records they can download and have each on a separate form with an upload button for each and get the user to them one at a time, alternatively do it using check boxes displayed the way the webmail clients do with a single hit. It doesn't use an array though.

You might be best searching the javascript forums!