I am now in charge of a large collection (about 50) MS Access 2000 databases with one or more uses in different parts of the country. Each database is exactly the same when shipped that is same tables and forms and a hell of a lot of data already in it.

Now as we have split the database we can send updates to the front end to all these users

" Missing DLL files on computers that don't allow you to install them..." that was / is a killer but that is not really my question just a side gripe.

My question is this: I wish to create a new function for the database that goes like this.

VB Code:
  1. Function UpdateShape(Table, NewField, Value) as boolean

  2. Docmd. er um er um duuur hmmmm

What I want to do is construct a string conatining SQL.
The SQL must create a new record in a field in a table and give all current fields a value.

What format would my SQL take?