Excel: Data Access Macro Does Not Function with System 7.0.1

ID: Q79490

The information in this article applies to:

Microsoft Excel for the Macintosh, version 3.0
Macintosh system software version 7.0.1

SUMMARY

The Data Access Macro (DAM) from Microsoft Excel for the Macintosh version 3.0 will not function properly if you are using System 7.0.1. When the macro attempts to retrieve a list of servers, you will receive the following error message:

No valid hosts in DAL driver

There may be other problems associated with running DAM under System 7.0.1 as well.

Microsoft has confirmed this to be a problem in Microsoft Excel for the Macintosh version 3.0. This problem has been corrected in Microsoft Excel for the Macintosh version 4.0.

MORE INFORMATION

The DAM checks for the System software version to determine where to look for server information and which Data Access Language calls to make. If it encounters System 7.0, it retrieves host information from the DAL Preferences file in the Preferences folder in the System folder. If it encounters a System version other than 7.0, it looks for the Hosts.cl1 file in the System folder. System 7.0.1 is not recognized as a version of System 7.0 and is therefore is treated as System version 6.x.

To obtain new or updated Microsoft products, call Microsoft End User Sales at (800) 426-9400. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, see the Microsoft World Wide Offices Web site at:

http://www.microsoft.com/worldwide/default.htm

Reference(s):

"Microsoft Excel Database Access User's Guide," version 3.0, pages 1-3

Additional query words: DAM DAL SQL Query

Keywords :
Version :
Platform :
Issue type :