Append task using Access query

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - KERELA couples Enjoying SEX at NET CAFE HAI.......... Guys this web site s very useful to you........... How This site helps.......... how to earn money form online...... In this site, you wil earn more than 10000/- Rs per month.... its true ....... just login this site and << EARN MONEY >> www.freeonlinedollers.blogspot.com www.freedollers.blogspot.com www.moviesgossips.blogspot.com Tag: Append task using Access query Tag: 67366
  - 2
    - MachineName\UserName transfer on restore? I am restoring a client's database from the test environment to the production environment. The server names are completely different. However, all the usernames include the servername of the test server. I restored the WSS3.0 site successfully, but all my SharePoint users still have the old machine name in front of their username. Is there some global update I can do to replace the old machine name with the new one? (Crossing fingers hoping for an easy way to get this done). Thanks in advance! Charlene Tag: Append task using Access query Tag: 67363
  - 3
    - Use the parent Quick Launch on a subsite after it has been built? I am trying to figure out how to tell a subsite that I already created to use the quick links from its parent site. When I set up the new site, I chose the 'don't inherit quick links' option - but now I want to. Is there a way to do it? Or do I need to go through all the subsites and manually re-enter all the links? Tag: Append task using Access query Tag: 67361
  - 4
    - Dataview Problems with WSS Library I have a WSS 3.0 site that has 9 subsites, each with its own document libraries. I have been asked to set up a 10th site that contains, among other things, a dataview listing of the files in a library on site2. The problem is that this library uses folders, with each top folder having two or more subfolders. In the dataview that Sharepoint Designer gives me, I can only list the top folders. The user would like to see a sorted files-only list (the folders should not be shown), much like one of the views he has set up in the library itself. Is this possible? I have tried making the files-only view in the library the default view, but that does not seem to change how sharepoint creates the dataview. I tried setting the Properties of the Data Source to "Files Only", but that does not change anything. I am not a programmer, and the only tool at my disposal is Sharepoint Designer. Any ideas? hutch Tag: Append task using Access query Tag: 67359
  - 5
    - Custom parts or other software to enable more granular permissions? Does anyone know of a custom webpart or other product that would provide administrators more granular control over permission levels in WSS 3.0? Each specific permission option often contains multiple functions, for example the List Permission for: "Manage Lists - Create and delete lists, add or remove columns in a list, and add or remove public views of a list." I'd like to able to break this down and permit a user to add or remove public views of a list but NOT create/delete lists or add/remove columns. I'd love to find something that gives me the ability to slice and dice each component of the permissions as I need to. Any ideas? Does such a tool exist? Thanks Tag: Append task using Access query Tag: 67358
  - 6
    - Windows Sharepoint Service 3.0 Authentication and encryption Hi, Is anyone using authentication methods other than Windows authentication for their WSS 3/MOSS implemention? I'm thinking smart cards, certificates and things like that. Also, does anyone know if you can have different web applications in WSS 3/MOSS using different authentication methods, e.g. a standard site collection using ordinary windows auth and another more secure collection requiring the use of a smart card or something similar? Just one more, is there some way of encrypting the documents in a Sharepoint SQL server database so that database users would just get junk if they tried to extract a document record from the DB but Sharepoint can retrieve and decrypt the data using a certificate or something similar? Thanks! Sean Tag: Append task using Access query Tag: 67356
  - 7
    - incoming email Can someone give me a simple description on the best way to setup wss to receive mail from an exchange server? I would like to know the proper method.... how does it get from the exchange server to the sharepoint server.. i have smtp running on the wss server and was directing incoming mail directly to it, but now with exchange i'm not sure what to do... Tag: Append task using Access query Tag: 67348
  - 8
    - ERROR: 1572894 The server connection timed out. 12030 I have a WSS 2.0 installation with SQL Server 2005 running on win 2003 sp2. I am using smigrate to restore whole web site to a different server. However, I am always getting Ë?The server connection timedoutË? error. 14 Jul 2008 12:44:00 Site collection opened 14 Jul 2008 12:44:00 Authenticating against the web server. 14 Jul 2008 12:44:01 Site opened Progress: Opening service Progress: Finished open service http://whatsup Progress: Reading manifest: counting tasks Progress: Beginning restore of Progress: Sending manifest Progress: Finished sending manifest Progress: The server connection timed out. Progress: All sites restored 14 Jul 2008 12:44:29 ERROR (possibly fatal): ERROR: 1572894 The server connection timed out. 12030 14 Jul 2008 12:44:00 Site closed 14 Jul 2008 12:49:00 Site collection closed Can some one please help Thanks, Tag: Append task using Access query Tag: 67346
  - 9
    - Add 100 GB of Data I am hoping this is the right place to ask, if not please point me in the correct direction. I am currently running a Windows 2003 server and WSS 3.0. Honeslty I can't remember how big the current Hard Drive config is, but that is irrelevant. I have to add 100 GB of data to the site and I don't have that much room. What is the best practices for doing this. Should I purchase another server and set up a portal? Set up a NAS device, and get WSS to use that drive? I need some help here please. Thanks in advance. Tag: Append task using Access query Tag: 67345
  - 10
    - Usage analysis processing is not running I'm having trouble with Site Usage Report in WSS3 SP1. In the Site Settings, the Site usage report says "A usage report is not available for this site and bla-bla". While I have configured "Enable logging" and "Enable usage analysis processing" in the "Central Administration > Operations > Usage Analysis Processing". I also see the job definition in the Timer Job Definitions area. stsadm -o getproperty -pn job-usage-analysis -url http://... returns <Property Exist="Yes" Value="every 1 minutes between 0 and 59" /> however nothing happens, except the following in the log file OWSTIMER.EXE (0x12734) Unknown SPRequest error occurred. More information: 0x80070005 OWSTIMER.EXE (0x12734) Unexpected ERROR: Failed invoking job id {2660A947-B893-450C-9FA0-ABC6FC6EAB82} Any ideas? I tried to google and don't find anything useful so far. I checked rights on \LOG directory for WSS_WPG account - OK, I added this account to C:\windows\tasks (read-write). Tried to check the job programmatically using foreach (SPJobDefinition job in site.WebApplication.JobDefinitions) { if (job.Title == "Usage Analysis") { Console.WriteLine("IsDisabled=" + job.IsDisabled); Console.WriteLine("LastRunTime=" + job.LastRunTime.ToString()); Console.WriteLine("Status=" + job.Status); Console.WriteLine("Schedule=" + job.Schedule.GetType().ToString().Remove(0, 21)); Console.WriteLine("NextOccurrence=" + job.Schedule.NextOccurrence(DateTime.Now).ToString()); job.Execute(site.ContentDatabase.Id); } } that returns following IsDisabled=False LastRunTime=01.01.0001 00:00:00 Status=Online Schedule=SPMinuteSchedule NextOccurrence=14.07.2008 15:02:39 but as you see the LastRunTime value is 01.01.0001 00:00:00 that means it was never executed... Any help would be much appreciated, Alexey Smirnov [MVP] Tag: Append task using Access query Tag: 67342
  - 11
    - Web Part Error: This page has encountered a critical error. Hi, I have problem with WSS v.3 migration from one farm to another. Old farm uses Windows Web Server 2008 x64 as frontend and Windows Server 2003 R2 SP2 x86 with SQL Server 2005 SP2 x86 as backend. The new farm uses Windows Server 2008 x64 as front end and Windows Server 2008 x64 with SQL 2005 SP2 x64 as backend. For migration I use Backup and Restore through SharePoint Central Administration Web. Both farms are installed in Manual account creation mode. I have tested new farm, if I create new WSS Application on it it works just fine. I performed restore through SharePoint Central Administration on new farm and it finished without errors, also I made iisreset /noforce after restoration. When I navigate to restored website I get the same error on every list and main page: Web Part Error: This page has encountered a critical error. Contact your system administrator if this problem persists. I have tried to restore several different WSS sites from the old farm, but error is the same on all of them. Any ideas, where to search for the root of this problem? Tag: Append task using Access query Tag: 67340
  - 12
    - Survey text Sharepoint 2007 I try to put a Q(question) in two lines like: ----------------- This survey is limited in 2 weeks. What is your department? ------------------ But in survey answer mode I get ------------------ This survey is limited in 2 weeks. What is your department? ------------------- So. How coud I enter CR into Q. In SP 2003 you yust Enter is enough. -- Thanks IJ Tag: Append task using Access query Tag: 67339
  - 13
    - Maintaining hierarchy Dear colleagues, In a custom list; I would like to implement a directory that may have the following options: 1.) Categories may contain subcategories and so on. 2.) An item may belong to more than one category or sub-category. For example: If Microsoft company would be included in the directory and we have some categories such as: 1. IT 1.1 Software 1.2 Hardware 2. Finance 3. Research and assuming we would like to add Microsoft web site to the directory and that it belongs to (1. IT), (1.1 Software), (1.2 Hardware) and (3. Research), figuring out a suitable approach causes me headache! The reason is that I'm limited to not using any thing other than Sharepoint. I implemented a content type of type folder in order for me to maintain the hierarchy of categories; should an item belong to a single category or sub-category, then another content type in the list of type item would work just fine; however, the intersection of association as in the Microsoft example doesn't make that approach suitable. If would use a webpart, that would be some how ok, but I must leave the user use the standard default "NewForm" and "EditForm". Some may wonder, why not using the Site Directory; it's an approach being studied at the moment, but the current approach is to use a custom list. Any suggestions are highly appreciated Regards Tag: Append task using Access query Tag: 67338
  - 14
    - Newbie permission error I can't figure out who the website administrator is I have Sharepoint 2.0 running on SBS 2003 R2 and it appears that the dbo of the STS databases are a group SBS Admin of which I am a member. The Administrator of the domain is also and administrator. Each time I attempt to make changes, the permissions are denied. Is the website administrator a service account? Can permissions be set through SQL server by adding another user to the STS databases with dbo permissions or is it really convoluted? If the latter, how do I determine who or what the website administrator is? -- Regards, Jamie Tag: Append task using Access query Tag: 67336
  - 15
    - WSS FAQ additions and changes - 29th June - 5th July 2008 Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ site and to this file. I can't guarantee that they still are. (This is also posted to my blog at http://mikewalsh.bilsimser.com) (Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.) From 29th June 2008 - 5th July 2008 NOTE: Amendment to KB articles: Microsoft are not not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance). This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0). Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place. I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me. I.1 2007 KB Articles (*now only one section for WSS and MOSS*) New http://support.microsoft.com/default.aspx?scid=kb;en-us;952288 Description of the Windows SharePoint Services 3.0 hotfix package: May 8, 2008 10th July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;953137 Description of the SharePoint Server 2007 post-2007 Microsoft Office servers Service Pack 1 hotfix package: May 29, 2008 9th July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;952294 Description of the SharePoint Server 2007 hotfix package: May 8, 2008 9th July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;951249 You do not receive search alerts when you use the FullTextSqlQuery object to perform a full-text search of a server that is running SharePoint Server 2007 8th July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;952683 The welcome name on a site is not changed as expected after you edit the name of a user profile in SharePoint Server 2007 8th July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;955377 Error "Cannot copy file: Cannot read from the source file or disk." copying items under the Documents node in Visual Studio Team Explorer (Warning: TFS ONLY) 7th July 2008 Modified http://support.microsoft.com/default.aspx?scid=kb;en-us;932619 You cannot crawl case-sensitive Web content in SharePoint Server 2007 (ver 3.0) 7th July 2008 I.b Forefront KB Articles New or Modified None I.c InfoPath 2007 KB Articles New or Modified None II. Articles - 2007 Products (no longer with all links to articles for other Office 2007 and other 2007 Products) New A. Office 2007 Server Products http://msdn.microsoft.com/en-us/magazine/cc700347.aspx Automated SharePoint Site Branding (MSDN Magazine July 2008, Ted Pattison) 8th July 2008 (date added) http://msdn.microsoft.com/en-us/magazine/cc507633.aspx Automate Web App Deployment with the SharePoint API (MSDN Magazine May 2008 - Ethan Wilansky, Paul Olszewski, Rick Sneddon) 8th July 2008 (date added) http://msdn.microsoft.com/en-us/magazine/cc337895.aspx Simplify SharePoint Development with STSDEV (MSDN Magazine March 2008 - Ted Pattison) 8th July 2008 (date added) http://msdn.microsoft.com/en-us/magazine/cc163287.aspx Security Programming in SharePoint 2007 (MSDN Magazine February 2008 - Ted Pattison) 8th July 2008 (date added) http://msdn.microsoft.com/en-us/magazine/cc163306.aspx You Should Learn SharePoint (MSDN Magazine December 2008 - Robert Bogue) 8th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc288413.aspx Index for Stsadm operations and properties (Windows SharePoint Services) (updated 30th Jun 2008) 6th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc508987(TechNet.10).aspx SharePoint Administration Toolkit (Windows SharePoint Services) (Updated 8th May 2008) 6th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc508983(TechNet.10).aspx Uninstalling SharePoint Administration Toolkit (Windows SharePoint Services) (updated 8th May 2008) 6th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc508980(TechNet.10).aspx Updatealert stsadm operation (Windows SharePoint Services) (updated 8th May 2008) 6th July 2008 (date added) http://go.microsoft.com/fwlink/?LinkID=117212&clcid=0x409 Microsoft SharePoint Administration Toolkit (White Paper -Kirk Stark) (updated 30th April 2008) 6th July 2008 (date added) http://go.microsoft.com/fwlink/?LinkId=86962&clcid=0x409 Evaluation guide for Windows SharePoint Services 3.0 technology (updated 5th April 2008) 6th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc287748(TechNet.10).aspx Deploy a simple farm on the Windows Server 2008 operating system (Windows SharePoint Services) (updated 30th June 2008) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc263408(TechNet.10).aspx Deploy a simple farm on the Windows Server 2008 operating system (Office SharePoint Server) (updated 30th June 2008) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc287960(TechNet.10).aspx Deploy in a simple server farm (Windows SharePoint Services) (updated 30th June 2008) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc287827(TechNet.10).aspx Install Windows SharePoint Services 3.0 and run the SharePoint Products and Technologies configuration wizard (updated 30th June 2008) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc262079(TechNet.10).aspx Install Office SharePoint Server 2007 and run the SharePoint Products and Technologies configuration wizard (updated 30th June 2008) 5th July 2008 (date added) http://go.microsoft.com/fwlink/?LinkId=121877 Best Practices for developing accessible web sites in Microsoft Office SharePoint Server 2007 (Waldek Mastykarz, Imtech) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc512092(TechNet.10).aspx Restore SSO (Office SharePoint Server 2007) (Office SharePoint Server 2007) (updated 30th June 2008) 5th July 2008 (date added) B. Other Office 2007 products None C. Other relevant products None Modified http://technet.microsoft.com/en-us/library/cc262869(TechNet.10).aspx (url changed too) Deploy using DBA-created databases (Office SharePoint Server) (updated 30th June 2008) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc262243(TechNet.10).aspx (url changed too) Deploy in a simple server farm (Office SharePoint Server) (updated 30th June 2008) 5th July 2008 (date added) http://technet.microsoft.com/en-us/library/cc512096(TechNet.10).aspx (url changed) Back up and restore SSO (Office SharePoint Server 2007) (updated 30th June 2008) (title changed to - to SSO from single sign on!) 5th July 2008 (date added) Deleted None III WebCasts (+ PodCasts, On-Line courses) for 2007 Products None IV WSS v3 FAQ New None Modified None --------------------------------------------------------------------------- V WSSv2 KB Articles (plus SPS 2003 Hot fixes) New None Modified http://support.microsoft.com/default.aspx?scid=kb;EN-US;870853 Office 2003 and 2007 Office documents open read-only in Internet Explorer (ver 6.0) 30th June 2008 VI WSSv2 FAQ New None Modified http://wss.asaris.de/sites/walsh/Lists/WSS%20FAQ/EditForm.aspx?ID=12 I.07.06 How do I ensure that .pdf files are included in the Search function? http://wss.asaris.de/sites/walsh/Lists/WSS%20FAQ/EditForm.aspx?ID=193 III.59 How can I make the link between Web Part Connections a dropdown list rather than the standard radio buttons? http://wss.asaris.de/sites/walsh/Lists/WSS%20FAQ/EditForm.aspx?ID=304 IV.23 How do I remove the *headings* in Quick Launch? VII. MS Articles New or Modified None Tag: Append task using Access query Tag: 67335
  - 16
    - Searching imported lists I have an imported list with thousands of items. How can I make it so that the user can search for a specific item (by ID number in the ID column for example) without having to make a new view everytime? Suggestions much appreciated. Tag: Append task using Access query Tag: 67331
  - 17
    - Filtering an imported list by user Hello, I have imported an excel spreadsheet, one of the columns contains the customer (Agent). I wish to filter the list so that users can only see the items which are relevant to them. The only way I can see to do this is to manually create a view which filters by their name, but there are too many customers and different views required to make this feasable. I've tried filtering using the Me function, (which returns exactly the same text as that which is in the Agent column), however, it is searching for the text "=PROPER(RIGHT(Me,LEN(Me)-9))" rather than the calculated value... The user didn't create any of the items, so how can I filter it to display only the relevant ones? It's been driving me mad, thanks for any help. Tag: Append task using Access query Tag: 67330
  - 18
    - Inbound e-mail file names converted to lower case I've enabled incoming email on a document library and although the attachments I send to the list are added to the list, their file names are always converted to lower case. Has anyone seen this? I've tried: * Different email formats (HTML, rich text, plain text) * Saving the original email to the library (.eml file shows correct file name casing) Nothing above has preserved the file names correctly. Tag: Append task using Access query Tag: 67328
  - 19
    - Paste image from clipboard into control? I am trying to adapt the HelpDesk sample SharePoint template for use in logging I.T. service requests. Users balk at the fact that there is no way to paste an image from the clipboard (e.g., explanatory screen shot) into the Service Request list item. On a test instance, I changed the "Details" control type to "Enhanced rich text", but pictures must be saved to files to be inserted. Any ideas? Thanks, Bill Le May Tag: Append task using Access query Tag: 67327
  - 20
    - Spell Check for WSS 3 Hi, Does WSS 3 have spell checking for the text boxes? I cant find a definitive yes or no answer (i can't find this functionality on our wss3sp1 installation). I've seen a number of posts about some 3rd party spellcheckers, but the posts seem to pre-date WSS 3. Tag: Append task using Access query Tag: 67318
  - 21
    - WSS3 SQL2005 - move databases Hello, I am using WSS3 with my config and content databases in SQL2005 on the same machine. I would like to move both databses to a SQL instance on a different machine. Is there any simple way to do this? Thanks! Tag: Append task using Access query Tag: 67316
  - 22
    - creating branching logic in a SharePoint 2007 list Is there a way to take the branching logic that is in a sharepoint 2007 survey and have the same functionality in a sharepoint list? I'm trying to create a process using a flowchart, but I want to be able to branch the information to certain questions in the list. Tag: Append task using Access query Tag: 67315
  - 23
    - Customizing Helpdesk prebuilt template Hello all, I download the 40 templates for wss 3.0 and installed the Helpdesk one. I am curious on how you can customize the forms contained within. The one I was looking at specifically was the New Service Request form. I wanted to try and prepopulate the Customer field on the NewForm.aspx with the current logged in user. Basically trying to leverage the User.Identity.Name or something of that nature. Any thoughts on how this could be accomplished? It may be more trouble than it is worth. Thanks, Greg Tag: Append task using Access query Tag: 67308
  - 24
    - Listing Information for Shared Documents? I am using windows sharepoint and I am uploading sales orders into the shared documents. The shared documents view shows "type", "name", "modified", and "modified by" as fields, but I need to create my own fields to provide information about the document such as customer and ID number. I was wondering how I could go about uploading a document with this type of information onto sharepoint. Tag: Append task using Access query Tag: 67298
  - 25
    - Bug in Alerts Can someone confirm if this is a bug? Here are the steps 1. Create an announcements list 2. Create a "assignedperson" column in the new announcements list (allow multiple people) 3. Create a view on the announcments list with filter set to "assignedperson=[Me]" 4. Set an alert and choose this view in the "Send me an alert when:" section When I use only myself in the assignedperson field, I get the alert When I assign myself and someone else, the item displays properly in the view, but the alert is not sent. Can anyone confirm this is a bug. Does anyone know if Microsoft is reading these groups everyday? Tag: Append task using Access query Tag: 67294
- Next
  - 1
    - Method 'Post' of object 'IOWSPostData' failed Hi! I have Microsoft Office 2003 and Microsoft Sharepoint Designer 2007 on the same machine. I have a problem uploading an excel spreadsheet into WSS 3.0. I get Method 'Post' of object 'IOWSPostData' failed error. I have followed this article (http://mindsharpblogs.com/Kathy/archive/2008/03/16/4450.aspx) but it doesn't resolve the issue. Pls, advise how can I resolve this. Thank you in advance! Zaur Tag: Append task using Access query Tag: 67293
  - 2
    - backup up MOSS 2007 is it safe to backup MOSS 2007 with both SQL 2005 management studio AND central administration Tag: Append task using Access query Tag: 67290
  - 3
    - How to upgrade wss2.0 to wss 3.0 Now,I have two servers named server1 and server2. Server1 with wss2.0 and sql server 2000. Server2 with wss3.0 and sql server 2005. I want to move and upgrade the portals on server1 to server2. What should I do? Tag: Append task using Access query Tag: 67289
  - 4
    - Software Development Services, Software Outsourcing Services In India Software Development services in India suggest IT Solutions for Software outsourcing services, Software Design, affordable software technology and Programming Development by frequent Software Testing. More information for visit our site http://www.itoutsourcingservices.com/software_development.htm Tag: Append task using Access query Tag: 67286
  - 5
    - WSS FAQ additions and changes - 29th June - 5th July 2008 Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ site and to this file. I can't guarantee that they still are. (This is also posted to my blog at http://mikewalsh.bilsimser.com) (Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.) From 29th June 2008 - 5th July 2008 NOTE: Amendment to KB articles: Microsoft are not not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance). This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0). Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place. I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me. I.1 2007 KB Articles (*now only one section for WSS and MOSS*) New http://support.microsoft.com/default.aspx?scid=kb;en-us;953130 How to configure SharePoint Server 2007 and Excel Services for Kerberos authentication 2nd July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;953132 How to add lots of users to a site, to a list, or to a document library in Windows SharePoint Services 3.0 and in SharePoint Server 2007 1st July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;952704 Description of the SharePoint Server 2007 hotfix package: May 20, 2008 1st July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;952698 Description of the Windows SharePoint Services 3.0 hotfix package: May 20, 2008 1st July 2008 http://support.microsoft.com/default.aspx?scid=kb;en-us;953484 Description of the Windows SharePoint Services 3.0 hotfix package: May 5, 2008 27th June 2008 Modified http://support.microsoft.com/default.aspx?scid=kb;en-us;909506 You cannot view a list in Datasheet view on a Windows SharePoint Services Web site (ver 4.0) 1st July 2008 I.b Forefront KB Articles New or Modified None I.c InfoPath 2007 KB Articles New or Modified None II. Articles - 2007 Products (no longer with all links to articles for other Office 2007 and other 2007 Products) New A. Office 2007 Server Products http://technet.microsoft.com/en-gb/magazine/cc718983.aspx Delivering Accessible Solutions using Microsoft Office SharePoint Server 2007 (Mark Harrison (MSFT), Henny Swan (Royal Institute of the Blind) 3rd July 2008 (date added) http://technet.microsoft.com/en-gb/magazine/cc718983.aspx Inside SharePoint Troubleshoot Messaging Integration (TechNet Mag, August 2008 - Pav Cherny) 3rd July 2008 (date added - article is from August issue of Mag) http://www.microsoft.com/downloads/details.aspx?familyid=5e94ad07-902c-422f-aadd-ff2bba9e540a&displaylang=en&tm SharePoint Products and Technologies Protocol Documentation (ver 0708) 27th June 2008 B. Other Office 2007 products None C. Other relevant products None Modified http://www.microsoft.com/downloads/details.aspx?familyid=e06453b8-b2dd-4177-969c-2f89aa841e11&displaylang=en&tm Microsoft Forefront Security for SharePoint with Service Pack 2 (ver 10.1.0802.0) 27th June 2008 Deleted None III WebCasts (+ PodCasts, On-Line courses) for 2007 Products http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032380043&EventCategory=5&culture=en-US&CountryCode=US MSDN Webcast: Integrating SAP Software with Microsoft Office Programs and SharePoint Server (Level 300) (Steve Fox, Jürgen Daibert) 30th June 2008 http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032379791&EventCategory=5&culture=en-US&CountryCode=US TechNet Webcast: Extending Excel with Excel Services (Level 200) (Pej Javaheri) 26th June 2008 IV WSS v3 FAQ New None Modified http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/EditForm.aspx?ID=971 I.31.01 What issues are fixed in the hot fixes to WSS 3.0? http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/EditForm.aspx?ID=958 I.31.02 What issues are fixed in the hot fixes to MOSS 2007? V WSSv2 KB Articles (plus SPS 2003 Hot fixes) New or Modified None VI WSSv2 FAQ New or Modified None VII. MS Articles New or Modified None Tag: Append task using Access query Tag: 67285
  - 6
    - Cannot sync onenote to sharepoint My collegue cannot open or synzronize onenotefiles from within onenot. He can upload a onenote file to the sharepoint server from the web- interface. He can open the file from the onenote interface on the hompage of sharepoint He can NOT open the file on the srver from within onenote... He cannot, when having the file opened in onenote, synch the file (after chances) from within onenote OR he cannot start a shared notebook saving it to the sharepoint server from within onenote So - it seems that from within onenote he only has one way communication with the server.... The following error message (in swedish) appear when trying to synch: "Not connected" And under the Error tab it then sais: The given networkname is in the wrong format (translated from swedish) (Error code: 0x4BE) When trying to open a file or start a shared notebook on the sps the following error appears: "invalid foldername" (translated from swedish) Tag: Append task using Access query Tag: 67281
  - 7
    - Is it possible to use custom server control against delegate contr Is it possible to use custom server control against delegate control? In my project I need to create a delegate control in the master page, then I try to use a custom server control to replace the default control in the delegate control, I hope that one expert can give me the sample of feature.xml and element.xml and the delegate control html, or some good links. Thanks. Tag: Append task using Access query Tag: 67272
  - 8
    - WSS Search Problem We've managed to create a major headache here... hope you can help. We created a WSS 3.0 site on a Windows 2003 server using the built-in SQL Express as the database. All was working very well, including Search, until we made the site public through Alternate Access Mappings. Unfortunately, a misunderstanding of what to enter in AMM ( the IT admin changed the "default" name, instead of adding the Internet Header) caused the problem. While the site still "worked", a SiteSearch came back with nothing. We fixed the AAM entry,, but now Search refuses to re-index all the docs, wikis and pages that are currently in the site. But, if we add a new item/doc, or if an item is changed, Search *will* find and index that item. But all the stuff we loaded in the trial stage does not appear in any search results. I have tried a restart on Search- no luck. Is there a way to force Search to recrawl the entire Site Collection? Thanks! BH Tag: Append task using Access query Tag: 67269
  - 9
    - Multiple SharePoint Databases Hi All, We currently have one SharePoint 2007 farm hosted in the US. Our problem is that when users in other geographical regions (Ex: Argentina) needs to upload or download files they experience lots of latency as a result of bandwidth limitations. Is there any way to have a second content database in that remote office in order to decrease the amount of time it takes to download and upload documents? Or is there any other work around? Thanks all Tag: Append task using Access query Tag: 67268
  - 10
    - Sharepoint libraries Hi, It would be great if someone could let me know if there is a way to have a single library where I can upload docs, add links & create wikis. Curretly I can create a lib where I can only do the 1st two or create another lib for wiki Regards, Kurian Tag: Append task using Access query Tag: 67264
  - 11
    - Converting Access database for use in WSS3 Hi! I have an Access database and application which I need to re-create in web interface, I mean make the similar application in WSS 3 site. I have created a new database in SQL Server 2005 and exported all tables from Access into this database. I wanted to know, what is the correct way of visualizing tables and data? Using lists? Or creating Data Views with Sharepoint Designer? I don't know much about the WSS yet, I'm learning, so any help is greately appreciated. Tag: Append task using Access query Tag: 67263
  - 12
    - Site users webpart how-to. Another question is that it still remains unclear to me on how to handle users, permissions in WSS 3.0. Also, I have a webpart on my default page which is Site Users. I was thinking that it will display any users logged in (from Active Directory) but it's not so. It shows me my user name and three groups (Site Member, Owners and Contributors). is there a way to display any logged in user in this web part or its designed for some other reason? Tag: Append task using Access query Tag: 67262
  - 13
    - Error when adding a new webpart Hi! In my WSS3.0 site I was trying to add a Site Users webpart to a default page but receive this error: Unable to add selected web part(s). Site Users: An error has occured. It was working before though... Yesterday, I was messing with SQL Server permissions. Could it be due to this? How can I troubleshoot it? Is there a way to reset everything to default as far as permissions are concerned and to keep the site content as is? Tag: Append task using Access query Tag: 67261
  - 14
    - Search Server Hello, I hope this is the correct group to post this question. We recently instsalled Sharepoint Services on a server running Windows 2003 Server and SQL 2005 Std. We have been using this now for a short time and recently noticed that it was not possible to search our site. We get the following message: Your search cannot be completed because this site is not assigned to an indexer. Contact your administrator for more information. I am quite new to Sharepoint and may be running before I can walk. Could somebody suggest the best method to resolve this issue and get the search feature working on our site. Thanks Nick I checked on the server and found that the Sharepoint search service was disabled. I have now set this to automatic and it seeems to be running fine using the system account. However when I try to select the server for the content database it does not allow me do do so, Tag: Append task using Access query Tag: 67252
  - 15
    - ERROR - The data source control failed to execute the update command. I'm running a WSS 3.0 and SQL Server 2005 Standard. I've created an aspx page whith a Single item Form. Data from SQL Server database tables is shown correctly, however when I try to modify the data and save it, I get the following error : The data source control failed to execute the update command. How can I troubleshoot and solve this? Thank you! Tag: Append task using Access query Tag: 67249
  - 16
    - SharePoint Rookie needs a little help All, I created a Sharepoint site for some events that will take place every two weeks. I successfully created the events on the calendar, but don't see how to invite people or groups. I did manage to create a "workspace" for each event and a list of users for the site. I need them to be invited and accept the meeting invitations and/or change their attendance status if possible. In short, I would like to see the functionality of the Outlook Calendar objects with the nice centralization that SharePoint seems to offer. Thank you in advance! McG Tag: Append task using Access query Tag: 67248
  - 17
    - Error "The server returned a non-specific error when trying to get data from the data source." When connecting to XML Data Source in SPD 2007 Hi! i'm trying to follow this article: http://office.microsoft.com/en-us/sharepointdesigner/HA101191141033.aspx to learn creating form DataViews. I create an XML file as described, however when I click on xml file and select "show data" data source details tab has all buttons dimmed and gives this error: The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator. On Muicrosoft site I've found this article: http://support.microsoft.com/?scid=kb%3Ben-us%3B923173&x=12&y=13 however, I connect to SharePoint site directly through the LAN, so why would I configure the proxy? Any clues? Thanks in advance! Zaur Tag: Append task using Access query Tag: 67247
  - 18
    - HOT NEWS FROM MICROSOFT....... YES ITS REALLY HEART BREAKING NEWS FOR EVERYONE http://polticsinfs.blogspot.com/ Tag: Append task using Access query Tag: 67246
  - 19
    - Cannot see my partners Changes in onenote s.p doc I uploaded a shared notebook from onenote on our sharepoint-server. My partner managed to open it in onenote (after som hassle). He managed to make some changes, see my changes, but! I cannot see his changes. I can erase his changes (those that I cannot see) Yes, I did make my partner editor of the document. We also tried this on the Office Live Small business. Same result Anybody knows a fix for this? I have SP1 installed - I do not yet know if my partner has that. A related problem might be that it seems impossible for my partner to open the document from within Onenote - he has to do it via the s.p server (or Live Small business..) Soon desperate for helpt... Mattias Tag: Append task using Access query Tag: 67243
  - 20
    - TFS Portals backup Hi. I am defining a strategy for backup of my TFS server. I understand that backing up the data tier keeps my version control, work items etc. safe, but I am uncertain about the Sharepoint portals. For example, when my users upload documents to a portal, are they also stored on SQL Server? And if I customize some aspect of a portal, where are they stored? I am thinking about creating a backup for my data tier and another for the sites of my server. Is this the correct approach? Best regards, Robert Scheer Tag: Append task using Access query Tag: 67241
  - 21
    - Event Receivers don't fired when using forms authentication Hi, I have programmatically registered some event receivers like ItemAdded, ItemUpdating, etc. to perform some security settings on the items. That works perfect when accessing the site via Windows authentication, but for one or another reason these events don't fire when accessing the website via Forms authentication. My WSS v3 site is accessible via a default zone using Windows authentication and also via a zone Internet with forms authentication. Is there anybody who has an idea why event handling doesn't work with forms authentication or what the cause could be? Thanks, Bert Tag: Append task using Access query Tag: 67238
  - 22
    - Windows Workflow ReplicatorActivity within WhileActivity Hello, I have a Workflow (for MOSS) that uses a ReplicatorActivity. It works fine when I use the replicator as a simple forward only action, but it fails when I put the replicator in a while actitivity, the ChildInitialized Event Handler is not called at all. Is there anyone who faced the same problem and managed to solve it? BR, DaniX Tag: Append task using Access query Tag: 67235
  - 23
    - email-form Hi, I'd like to implement the possibility to fill out a form and when clicking this button the filled form should be sent by mail.. Actually we don't have Info Path Form Services.. Is there a way to implement form services (or any other kind of form- based email sending) to sharepoint services 3? rgds Tag: Append task using Access query Tag: 67232
  - 24
    - Combine values from another List Hello, I want to obtain values from two columns on another List but don't know how to do this. For example, I have a Contact List with First Name and Last Name. I have a Job List and I want to have a column where I can select from a list of First Name, Last Name pairs from the Contact List. It appears that I can either include First Name or Last Name, or I can concatenate First Name and Last Name on the Contact List but this column is not allowed to be used as a menu selection in the Job List. Tag: Append task using Access query Tag: 67228
  - 25
    - Creating KPI using Excel Workbook When I create a KPI and click on the Excel icon on the side of where you enter the indicator value (so that you can select the cell that the value is in), the screen that pops up says "a web part on this page has property settings defined in tags that contain invalid XML". Any ideas to how i can fix this. Thanks in advance. Tag: Append task using Access query Tag: 67227

What is the secret to appending the Assigned To: field of a task?

I have an Access append query that is successfully appending
everything else to a task list except for the Assigned To: field. I
tried using the UserInfo ID and also the name string. Neither has
worked. I get no error. Everything else posts but the Assigned To:
is left blank.

Top

Re: Append task using Access query by Jason

Jason
Thu Jul 17 14:14:09 CDT 2008

On Jul 17, 4:40=A0am, Jason <JT49...@gmail.com> wrote:
> What is the secret to appending the Assigned To: field of a task?
>
> I have an Access append query that is successfully appending
> everything else to a task list except for the Assigned To: field. =A0I
> tried using the UserInfo ID and also the name string. =A0Neither has
> worked. =A0I get no error. =A0Everything else posts but the Assigned To:
> is left blank.

Thanks anyhow. I figured it out!
The correct value to post is neither the Name or the ID but instead
the AD user ID (eg. AD\user)

Top