"locking" And "protecting" Old Data

Please help!!! I am a newbie to Access and VB... but got bribed into deciphering and fixing this old database.

Old database from my wife's work. We have recreated an access database and pulled in all of the old data. The old design only allowed a client company to have one employee. The new design allows them to enter in a client and then pick which company they work for. (Was a one-to-one relationship between company and client and now is a one to many relationship.) The issue is that now all of the old projects for this company are assigned to the company and whoever the current employee is set to for the company (they would change the employee name every time a new project came in from that company). :rolleyes:

However, there are some records where they do only deal with one employee for a company. So those records are ok and should be kept "active". But in the other cases we need to be able to "freeze" these records and not allow the addition of any new projects (done as a subform on the client form) to this client record. This will need to be a one-time deal. So once these records are locked they should never have to unlock them... they do need them there for historical data and for reporting purposes. The plan is to change the client name for these records to something like "original company record" or something like that anyway. Then as a new project comes in... a new record will be added for the person and they will be linked to the company but all of the new projects will be added to this client... not to the original client/company record.

How do I make this happen? Again it will be done on a record by record basis and there will probably only be around 600 records or so that will need to be locked down. And no new records should come up that will be locked down.

Thanks for any info!!!