Board index » off-topic » Excel-GoldMine BDE Link error
Wendy Collett
Delphi Developer |
Excel-GoldMine BDE Link error2004-06-17 08:48:18 AM off-topic11 Hi all, Hope you can help me, I'm asking everybody on all newsgroups on this one, and hope you might have an answer the others don't have. GoldMine 6.5.40321 is a dBase IV program, based on BDE 500. It can and has done for many years, linked to MS Word versions via BDE to perform merge documents etc from the information in GM. In the latest (6.5) version of GM, they have also provided a link for MS Excel, which was based on the same technology as the successful Word link. In probably 90% of cases, the link to Excel does work (regardless of Excel 2000, XP or 2003), but sometimes it doesn't, for reasons I have not been able to track down. In all cases, the link to Word works 100%, even if the Excel link doesn't. While it might be a coincidence, each unit where the link does not work, is a Excel XP (original version, or SP3) machine, with simple users, no extra programs causing links or program problems. The link to Excel appears to install the link correctly, as a menu item in Excel. When clicked upon, the link gives back a -1BDE error indicating it can't connect to the BDE. In other cases where this error has occurred, it has been easy to fix and get working by changing the SHAREMEMLOCATION in the BDE settings from the original install default of 7000, to one of these: 6BDE, 5BDE, 4096, 1024. But I still have some sites where this does not make any changes, nor did upgrading the SP on Excel to SP3 (avoiding SP2 was noted), or an upgrade to GoldMine version or Excel Link version. (For other information, I have checked that the macro security level in Excel is set to Low, replaced the normal.dot file, and that the add-in has not been disabled by Excel.) If anyone has any thoughts on this matter, and how or if the BDE might in some way be adjusted further to get this link working, I would be most appreciative. TIA, Wendy Collett Seahorse Data GoldMine Consultant, Brisbane, Australia |