Michael R Mattys
michael.mattys at adelphia.net
Fri Oct 1 10:35:31 CDT 2004
----- Original Message ----- From: "Bob Heygood" <bheygood at abestsystems.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Friday, October 01, 2004 10:37 AM Subject: [AccessD] Access - Advantage - Mediwin > hello to the list, > I created an app years ago that interfaced with the client's medical > practice software. > The software is Mediwin, which uses the Advantage db engine. > After an upgrade to the Mediwin version, my ODBC calls fail for "Can't lock > all records" message from Jet. Some pursuit of the ODBC help indicates that > a network failure could also be an issue. And sure enough, they had the > network guy in about the same time. > Very odd that I can still link to the table of interest sometimes and even > export to Excel, but can't open the table in datasheet view nor successfully > run any of my code. <snip> Bob, I am working with another medical practice software called DME VI (formerly Dezine) whose creators have decided to make their own data definition files and ODBC drivers to prevent linking to their tables without paying first. I wouldn't be surprised if this has/will become a standard practice in the medical software industry. You may want to check if that's the wall you've run into. ---- Michael R. Mattys Mattys MapLib for Microsoft MapPoint http://www.mattysconsulting.com