RE: Working with Sharepoint databases

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Harry Ng (harry_at_infocan.net)
Date: 07/30/04


Date: Fri, 30 Jul 2004 00:39:02 -0700

You can get more information from www.sharepointcustomization.com to customize your page. But, not to modify the database directly.

-- 
Harry Ng
harry@infocan.net
System Consultant
Microsoft Certified Trainer
INFOCAN Computer (HK) Limited
Tel: (852) 2882-2456
Fax: (852) 2882-2707
"Jamesy" wrote:
> Hi folks,
> I've found myself delving into the Sharepoint databases - mainly to
> try and recover data from a "Lost" site.
> 
> From what I can work out, the "lists", "Webs" and "docs" tables are
> the key ones and I've pretty much worked out their relationships with
> the visible portal.
> 
> I have come a bit unstuck, however, with the following ;
> 
> If I add a test jpeg to a test image library and find it by querying
> the docs table, I can edit the LastModified column and have that
> modification reflect if I refresh the relevant page in the portal.
> 
> I can also delete the three related rows in the docs table and have
> the item disappear from the image library.
> 
> Problem comes when I merge the three rows back in. Although - to all
> intents and purposes - the docs table is now back to it's former
> structure, I can't see the image in the image library. If I try to add
> it through the web interface, I can't - as the form sees that it's
> already there.
> 
> I can't find any reference to the actual image file or it's ID in any
> of the other tables, so I can't work out what else I need to edit to
> have the file appear to the browser interface.
> 
> Any ideas would be gratefully received.
> 
> All the best,
> 
> KJ
> 


Relevant Pages

  • Working with Sharepoint databases
    ... I can also delete the three related rows in the docs table and have ... it through the web interface, I can't - as the form sees that it's ... I can't find any reference to the actual image file or it's ID in any ... so I can't work out what else I need to edit to ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Allow me to type over an image file in word, without text boxes.
    ... image file, though u couldn't select or edit the image file its self. ... Kind of like when you protect the a word document with the 'form protect' ...
    (microsoft.public.word.drawing.graphics)
  • Check Out and Read Only Issues
    ... When I check out a file using the web interface then open it into my editer, ... I do get asked for a password, but I can download files or ... if I do go in via the exchange interface and check out a ... If I edit the checked out and downloaded document, when I want to save it ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: adding data to two tables at once with a form
    ... edit the related rows of the child table in the subform. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.access.forms)
  • Re: Convert Indesign file to Publisher
    ... Just send the image file, or a pdf and avoid the "Why can't I edit this" ...
    (microsoft.public.publisher)