How to modify connection string for DSN less linked table

[Guest]

We had a need to modify the SA password on our SQL Server. There is a legacy access aplication that uses linked tables pointing to our SQL Server. I checked the workstation of one of the users of the application and there is no DSN so I am assuming that the linked tables connect without a DSN. The problem is that I can not find where this can be modified in access. I looked at all the modules and did not see anything

Help!

 

[Phil Hunt]

Under Tools/Table Manager menu, you may find how the tables are linked. It
probably uses an ODBC.

We had a need to modify the SA password on our SQL Server. There is a

legacy access aplication that uses linked tables pointing to our SQL Server.
I checked the workstation of one of the users of the application and there
is no DSN so I am assuming that the linked tables connect without a DSN. The
problem is that I can not find where this can be modified in access. I
looked at all the modules and did not see anything.

 

[Tim Ferguson]

of one of the users of the
application and there is no DSN so I am assuming that the linked
tables connect without a DSN. The problem is that I can not find where
this can be modified in access.

Check the connect property of the tabledefs:

' use a proper variable here, not currentdb()
for each tdf in db.tabledefs
' you need to check the constant
if tdf.attibutes AND acLinkedTable Then
debug.print tdf.Name & ", " & tdf.Connect
End if

next tdf

The structure of the Connect property is explained in the help files, so
you can rebuild it with the correct access parameters.

Hope that helps


Tim F