Distributing database subsets

[perkon]

I have a master database containing detailed information about approximately 200 clients. I want to be able to automatically generate individual databases for each of those clients (limited to information just for that client) that could be sent to the clients, updated on the clients' computers and sent back. The updated information would then be imported into the master database.

Since the clients that would receive the database do not necessarily have Access installed, I guess this would need to be done somehow using a run-time version.

First of all, I am not familiar with run-time Access and am trying to determine if this is feasible to do.

Presuming this is practical, I am at somewhat of a loss as to how the process could be automated. Basically, I need to breakdown the master into 200 (or so) separate, personalized databases.

Any suggestions?

 

[AlanS]

Export each client's record to a separate Excel workbook, send that to the client for updates, then import the modified workbook back into the appropriate table record.