Hi All
I need to create a form that inputs from one datbase to another database. This ensures that the people inputting the information cannot see the second database that there inputting into only the information that they are inputting.

Regards

Brendan Bartley

__________________
Brendan Bartley

You can package the data, do data validation on the form, and then send the transaction to the other database, without being linked to the other database.

Need to know the type of the other database, and preferred method of talking with it, and some sample info that needs to be sent.

Data can also be retrieved.

I have a similar situation, and after the user enters their credentials, a connection is tested, then data is moved from the second database to local tables in the first, for reading, and then a form is opened where the user can do work. Then when they submit the changed record, the data is validated, and the transaction is sent using an ADO provider connection.

Does that sound like the sort of thing you are after?

mmcdonal

Look it up at: http://wrox.books24x7.com