V vik808 Registered User. Local time Yesterday, 17:44 Joined Jul 31, 2008 Messages 16 Feb 18, 2014 #1 Hey guys, I have a table that was linked from a SQL Server with a file DSN. It was linked years ago so now I want to locate that specific DSN file for that specific table if possible. Any ideas? Thanks in advance
Hey guys, I have a table that was linked from a SQL Server with a file DSN. It was linked years ago so now I want to locate that specific DSN file for that specific table if possible. Any ideas? Thanks in advance
G Galaxiom Super Moderator Staff member Local time Today, 10:44 Joined Jan 20, 2009 Messages 12,895 Feb 18, 2014 #2 Hover over the linked table in Access or read the tabledef's Connect property.
V vik808 Registered User. Local time Yesterday, 17:44 Joined Jul 31, 2008 Messages 16 Feb 18, 2014 #3 That's what I resorted to but I hovering over doesn't show the dsn filename which would be more usefull but thanks
That's what I resorted to but I hovering over doesn't show the dsn filename which would be more usefull but thanks
G Galaxiom Super Moderator Staff member Local time Today, 10:44 Joined Jan 20, 2009 Messages 12,895 Feb 18, 2014 #4 I normally use DSNless connections. It saves having to worry about where the file is located.