[AccessD] Open Access 2007 forms and reportsfromWindowsSharePoint Services

Martin Reid mwp.reid at qub.ac.uk
Wed Oct 11 12:57:04 CDT 2006


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
 
 
 
 


More information about the AccessD mailing list