> When attempting to use data accessing programs like MS Query, I get an
> error
> from previously saved queries that "Data source name not found and no
> default
> driver specified." Upon checking my data access setup I cannot see any of
> my
> ODBC Drivers. Using Regedit to look into my HKLM\Software\ODBC keys, I
> find
> no @="". Until updating to Windows XP Pro SP2, this worked fine. Any
> suggestions
There is an issue with SP2 and SQL Server. Did you install SQL Server SP3?
Re: Populating mail merge doc with data from MSsql 2K table ... > the MS Query option in Word - when you get to the Select Data Source ... Enter the name of the Windows computer that is running SQL Server... Word should now create the .odc file and select it as the data source.... if you did not sleect Windows Authentication and you did not ... (microsoft.public.word.mailmerge.fields)
RE: Use of IF then Else syntax in Access ... Is this being used in a query?... this is referring to a field in the query's data source.... that means using the SQL Server T-SQL syntax,... (microsoft.public.access.queries)
Re: Populating mail merge doc with data from MSsql 2K table ... MS Query is part of Office so you should have it already. ... You may see a dialog box saying "Confirm Data Source",... Enter the name of the Windows computer that is running SQL Server..."Windows Authentication" your permissions in SQL Server are associated with ... (microsoft.public.word.mailmerge.fields)
Re: Problem with blank entries being filled with other values ... You have a table in SQL Server 2000. ... Then you use a make table query in Access to create a table in Access. ... Or are you managing to use the Make table query as the data source for the ... > in the Counter field are replaced with values from this field in other ... (microsoft.public.word.mailmerge.fields)
Re: formatting mailmerge field ... when you use MS Query to set up a merge data source,... used to generate the SQL Query that Word uses to get the data. ... you can save your document as HTML format, open the HTML file using e.g. ... > in sql server.... (microsoft.public.word.mailmerge.fields)
