This a project which has been dumped in my lap and I know nothing
about it's history or construction. It's a complicated problem and I'm
struggling to simplify it but here goes:
I have a SQL Server 2000 database sitting on "MACHINE 1"
I have an Access 97 database, on a shared file server "MACHINE 2",
which contains 20 linked tables to the SQL database.
Several users have a desktop shortcut on their PCs ("MACHINES 3") to
the Access97 database.
I have added 3 new fields to an existing table in the SQL DB.
Essentially, I want to refresh the linked table to show the 3
additional fields but I can't find any obvious way of doing this. The
description property of the linked table shows:
ODBC;DRIVER=SQL Server;SERVER=ADCMUKQ03;UID=HAINEES;APP=Access CTR
App.;WSID=ADDMUKW7018;DATABASE=CTRData;TABLE=dbo.tblConfiguration
The connection string is identical for all the tables apart from the
last "TABLE=...." parameter.
According to Microsoft, the absence of the parameter "DSN=...." in the
connection string suggests this is a File DSN rather than a System or
Machine DSN. And, because it's a File DSN I can't use the Linked
Table Manager Add-in (It's a known bug that the add-in doesn't work
with File DSNs). So, does anyone know how I can refresh a Linked Table
which uses a File DSN ? Also, why isn't the name of the actual file
stored in the connection string ?
I suspect the the answer to this might be that I have to drop the
linked table and recreate it. I have also created a new table in the
SQL DB which needs to be linked to the Access DB. I want to use the
existing File DSN rather than create a new one. Incidently, if
you've read this far, your're doing really well. Keep going. If I'm
right in thinking that a file DSN is being used, I should be able to
link other tables using the same DSN if only I knew the File's name
and location. I've searched MACHINE 2 & 3 and can't find any File
DSNs. The name of the file isn't stated in the connection string so
I'm stuck. The connection string does, however, contain one of the
user's UserIDs but I don't know why and all users are able to use that
linked table despite this. So, does anyone know how to find the name &
location of a file DSN and how to link a new table using an existing DSN ?
Or, am I misuderstanding File DSNs altogether ?
Thanks very much for any help
Scott (UK)
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
