How to start another Access Program and pass it data

[sc5502]

Background: Front end: MS Access 2010/VBA, Back End: MS SQL Server 2008

Can one access program start another access program and pass it data. See attached for details.

Thanks.

[Rabbit]

Yes you can. Please read our article on application automation. http://bytes.com/topic/access/insigh...ion-automation

[twinnyfo]

is there a reason that simply linking tables would not work?