DDE converations

[elziko]

I'm trying to set up a DDE conversation between one instance of acces and another.

I have a button with the following code:

Dim AccessLoc As String
Dim Chan As Integer
Dim Database As String

AccessLoc = "C:\Program Files\Microsoft Office\Office\Msaccess.exe"
Database = "G:\Highways\Highways Software\Highways Photo Explorer\CentralPhotoDatabase.mdb"

Shell AccessLoc, 1
Chan = DDEInitiate("MSAccess", "System&quot

But I get an "Overflow" runtime error on the last line of code. I have no idea what this overflow is reffering to.

Can I not have one insatnce of access opening another instance of Acces and before setting up a conversation with it?

Any help, much appreciated

elziko

 

[DougP]

Overflow is usally Memory related. You are filing up the stack which roughly translates to memory.
How much RAM do you have?? DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[elziko]

The system this is to run on has got 64 Mbs.

I dont think that setting up such a conversation is gonna gobble memory. I've done the same sort of thing VB5 many many times with no problems.

 

[Scoty]

elziko,
From what I understand about DDE, If you are using WinNT you are in for a long hard road. DDE is a 16bit interface and NT is 32bit only. I have done some extensive research on this because I am intergrating legacy systems in an NT enviroment. I had many an over flow problem with dde. Simply put DDE is an Antique. You may want to consider just linking to the needed tables in the Other Data base. It may not be as "neat" but it will save you a lot of frustration.
Scoty
: