Hey All,
I am upsizing to SQL 2000 server and I am hoping to integrate it with an ADP front. I am having trouble deciding on the best method of adding new records from ADP. Information would be added to multiple linked tables at the same time (available in a view). I was wondering if a disconnected form would work best, with a stored procedure doing the work after the information is input or if performing the action using a bound view that has an updateable snapshot would work better..
Thanks for your input.
I am upsizing to SQL 2000 server and I am hoping to integrate it with an ADP front. I am having trouble deciding on the best method of adding new records from ADP. Information would be added to multiple linked tables at the same time (available in a view). I was wondering if a disconnected form would work best, with a stored procedure doing the work after the information is input or if performing the action using a bound view that has an updateable snapshot would work better..
Thanks for your input.