Posted on 2008-11-12
Last Modified: 2012-06-22
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?
Question by:HenryV1955
    LVL 38

    Expert Comment

    by:Jim P.
    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.

    Author Comment

    Hi jimpen
    thanks for your comment. mentioned 'hit the advanced'   advanced in where?

    LVL 38

    Accepted Solution

    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.
    LVL 38

    Expert Comment

    by:Jim P.
    Can I ask why a B grade?

    May all your days get brighter and brighter.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now