Shamil Salakhetdinov
shamil at users.mns.ru
Wed Oct 11 14:47:04 CDT 2006
<<< In a few months they will also release a tool that will shred you database into XML and allow you to create your own templates. >>> Yes, I see. Thank you. <<< Still gettign to grips with this bit. Hence my email re Load and Save from text a while back. The XML files are structued in teh same way as those methods produce. >>> OK - as I see this is a mix of XML and .SaveAsText produced files... But after all all the objects and data of a database are saved in this .accdt file, which is in fact a .zip file as you noted: - databaseProperties.xml - navpane.xml - relationships.xml - vbaReferences.xml - objects folder: tables - xsd of tables queries - SaveAstext forms - SaveAstext reports - SaveAstext macros - SaveAstext modules - SaveAstext - SampleData folder - xml file of the database tables data - _rels and properties subfolders - these are unclear - some small size xml files here with almost no information in them - what for are these? I guess files in _rels are to keep information about MS Access database objects' relationships/dependencies. And what for the files in properties foder? - I guess they plan to finally convert .SaveAsText files' info into .xml format? Right? Do they plan to release this tool you mention together with MS Access? So all the MS Access databases' contents including queries, forms, reports, ... will be possible soon to XML-ze/serialize, publish on SharePoint server as well as deserialize and run on client side... MS Access applications are becoming open source by definition?... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Wednesday, October 11, 2006 9:57 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Open Access 2007 forms andreportsfromWindowsSharePoint Services Shamil I actually like the ribbon. Old apps will work as is with command bars but no it replaces command bars in 2007 file types. The ribbon is an XML file using call backs so basically anything you can do in VBA call backs you can do with a ribbon. I would say with your skills you couldl make some really cool ribbon features. I had and am having a hard time with the XMl but will get there. THe cache as you say is for server data to client data. Its a bit of a security hoel as anyone then with access to teh DB has access to teh server data. But in a linked app its Active Directory security for the life time of the open application. Once linked a WSS lsit can be manipulated as if it where an Access table using DAO etc and works really well. TempVars are really used by Macros but available in VBA. They are macro variables. Attachment is a data type. New one in whch you can associate multiple files with a record. Very clever but if your upgrading to SQL Server useless. Its a sharepoint feature the ability to associate attachments with list items. Macros now have OnError statements In a few months they will also release a tool that will shred you database into XML and allow you to create your own templates. You can see hwo this works if you take an Access 2007 template file and rename it with a ZIP extension. Still gettign to grips with this bit. Hence my email re Load and Save from text a while back. The XML files are structued in teh same way as those methods produce. You can also save import/export specs for reuse. Martin