Making multiple copies of the backend database for a form??

The creation of the database is completely unrelated to the creation of the PDF. A PDF can only act on an existing DB. And there are several ways a PDF form can be connected to a database.

It's probably not necessary to have a different form for each project lead. You can control the interaction purely with information on the form. For example, a project ID. But this all depends on the specifics of your setup. Are the DBs local or remote? Is this an AcroForm or LiveCycle document?

thomp,
The DB's would have to be local. The form was a PDF converted to a fillable form. Not sure whether it was acroform or lifecycle. My understanding is lifecycle is used to develope a form from sratch, this is not the case. By default I guess it is acroform. I converted this form in acrobat 6.0 and updated it in acrobat 8.0.
My question now based on your answer is how do I create the DB and have it connected to the form?? Then how would I distribute to other Project leads.

To create a DB you'll need a DB tool like Access. Once the DB is created, with all the tables and columns, it will need to be registered with ODBC before it is visible to Acrobat.

ODBC is accessed through Acrobat JavaScript with the ADBC object. If the DB is setup correctly, and there are a lot of parameters, then you will be able to both read and write to it using SQL statements.

Look up the ADBC, and supporting objects, in the Acrobat JavaScript Reference.

http://www.adobe.com/devnet/acrobat/javascript.php