Thomas2016
New Member
- Joined
- Mar 1, 2016
- Messages
- 12
I've created a workbook with a simple data extraction from a SQL server that loads to a Table. It works great on my computer, but when I try to distribute it to other people, the Table's connection to the SQL Server query is lost, so they are unable to update the data in the table.
The workbook is not using a Connection File to get to the data. By the way, the Connection name does still appear in Data>Connections, but it is 1) disassociated from the output table, and 2) all of the properties (including the SQL query itself) have been cleared from the Connection>Properties.
Any help would be GREATLY appreciated.
The workbook is not using a Connection File to get to the data. By the way, the Connection name does still appear in Data>Connections, but it is 1) disassociated from the output table, and 2) all of the properties (including the SQL query itself) have been cleared from the Connection>Properties.
Any help would be GREATLY appreciated.