04-29-2004, 02:20 AM
How can I get an Access app to talk to a vb.net app - they need to pass each other data and possibly call public functions etc.
Is it possible to write a class in Access that sends and receives data through sockets?
Any advice much appreciated
04-29-2004, 07:02 AM
You can use Automation to controll Access. I don't know the Access Object Model (I'm an Excel-guy) but the ideas would be similar/parallel to the tutorial laid out here: Automating Office Programs with VB.Net (http://www.xtremevbtalk.com/showthread.php?t=160433)
That said, .Net still has it's problems trying to work with MS Office. .Net's COM Interop is tricky, at best. Deployment across systems with different versions of MS Office can be almost harrowing. If at all possible, I would develop in VB6 or VBA.
But I'd read that tutorial for a start...