I'm trying to set up a DDE connection between from Excel to Access. It seems
like it should be easy, but I'm having a world of trouble. Following the
(scanty) documentation on the subject I do the following:
This works as expected, returning an integer for TaskID.
AChannel =INITIATE("Microsoft Access", "Basdat")
The manuals suggests using "Access" or "MSACCESS" as 'app_text', but as
neither worked and "Microsoft Access" did, I used the latter. The manuals
also suggested using "BASDAT.MDB" instead of "Basdat". Again the latter
worked the former returned an error. Anyway, this seems to work and returns
a small integer for AChannel.