Here is an odd behavior. On an XP platform utilizing Access 97 to link to a 7.3 SAP database, when linking tables the link string truncates the datasource name by 1 to three chars. All other elements of link string okay.
When the table is linked the user has access to the table until Access is closed and restarted. Then the link craps out. Behavior is on one box only.
Tested link to another Access DB, normal
Tested link to SQL Server, normal.
Registry keys are correct.
The ODBC driver for SAP is the same as all other office machines which, of course, work perfect.