• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2715
  • Last Modified:

DSN WSID

I'm using Access 2003 and linked tables to SQL server 2005.
My question is, when I use the linked table manager and then ODBC to SQL server and link the table I want the WSID is the machine I am currently on. Does it affect others uisng their machines to access the data or should the WSID be the same for everyone?
0
HenryV1955
Asked:
HenryV1955
  • 3
1 Solution
 
Jim P.Commented:
It has no effect on anything, except when you view the data in the activity monitor or using sp_who command.

I usually make a point to hit the advanced and just clear it so that it doesn't fool you.
0
 
HenryV1955Author Commented:
Hi jimpen
thanks for your comment.
question.......you mentioned 'hit the advanced'   advanced in where?

thanks
0
 
Jim P.Commented:
Sorry, I meant Options.

The other thing to note, is if you change the Application Name, that also carries through to the SQL Activity Monitor.
Link-Tables-Options.jpg
0
 
Jim P.Commented:
Can I ask why a B grade?

May all your days get brighter and brighter.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now