Problems and Solutions>Databases
Changes to a data source are not visible from GhostFill
|
Problems and Solutions>Databases |
|
|
Changes to a data source are not visible from GhostFill |
|
|
Article #: |
0021 |
|
Contributor: |
Doug Simpson |
|
GF version: |
3.05 |
|
Applies to: |
The link between GhostFill and a data source |
|
Last updated: |
November 6, 2001 |
Problem
When browsing a DataLink, recent changes to tables and queries in a data source are not reflected.
Description
If you have added or changed tables and queries in a data source that uses a SQL Server driver, the changes do not appear immediately in GhostFill. If you have deleted objects from the data source, they sometimes remain visible and can even be amended from within GhostFill.
Solution
The same problem occurs in Microsoft Access when linked to SQL Server. The problem lies in the version of the SQL Server ODBC driver. Download and install the latest version of MDAC from the Microsoft Technical Support site: www.microsoft.com/data/download.htm