.Net User group on Wednesday 17th January 2007
No Pizza this time!...only sushi…..almost too healthy….
News:
Timesnapper great for seeing what you did for the day! Could help when you are doing your timesheets….as this is a different twist as it takes snapshots of your desktop at configured intervals…
Firebug which is an extension in firefox is great for checking your web sites….and you can even change things in the browser to see what it would look like if….
Virtual PC 2007 Release Candidate….Some said this was problematic…..compared with the beta…..
The new Expression Web looks like a great tool for pure web designers…..Except we don’t get it with MSDN!
http://www.microsoft.com/expression
What was nice is how is automatically creates separate css files etc which I normally have to do by editing the html pages.
It is also better for “cleaning” up a site as it shows you which styles etc are used and not used etc…
I think that SharePoint designer has almost the same features except for a few different wizards….and less standard compliant code for backward compatibility with Front Page.
Will need to play more with SharePoint designer though….
Note: Currently using SharePoint designer instead of front page 2003 and it works fine…..
The new Microsoft Access 2007 is great! And looks very sexy! …..All it needs now is Jenifer Hawkins…….
Anyway this product will be used by many business users for sure which means more work modifying and enhancing Access Databases for years to come.
Adam picked on me because I asked if the Access 2003 issue with multiple choice fields when linking to SharePoint was fixed in 2007!
Wow….now this many to many concept has been simplified and makes database design with Access so much easier and powerful!
Memo fields are now on steroids!..You can do rich text in memo fields….Now I can do my automated spamming ..oops I mean bulk emailing tool with nice text without any html stuffing around….
Memo fields also have versioning etc….
Graphics now can be stored a jpgs and even linked to a file on a hard disk.
Reports have alternative row colouring and an option.
Emails are fixed in Hyperlinks! Before if you used access to edit\update hyperlinked fields it would put an http in front of the mailto:....
Simple click to upgrade the tables to SharePoint or SQL Server.
Apparently some of the access guys went to the SharePoint team and then came back for the 2007 build….The end result is better linking with SharePoint and this powerful new feature.
Also all the ad-hoc querying is made more powerful in that you can sort, filter and even do aggregates without any coding or sql……
There’s a lot more to the new access even the format to cater for the multi-choice etc….But you can hook into older database versions….
Interesting feature is that you can’t reference both ADO and DAO in the references at the same time!...
This might cause some issues as this is needed sometimes when you use dao for linked table checking etc and ado for sql server access…..
There is no replication. No Security ( Every is putting their tables in SQL so that is where to security is) or you can use the older format for security.
The new formats .accdb, .accde, .accdt etc
Note renaming to .accdr can be used to simulate run-time….awesome…..
And lastly the pdf add-in…
Looking forward to using and deploying Access 2007
Tom Bizannes
Databases & Business Intelligence
http://www.smartbiz.com.au
News:
Timesnapper great for seeing what you did for the day! Could help when you are doing your timesheets….as this is a different twist as it takes snapshots of your desktop at configured intervals…
Firebug which is an extension in firefox is great for checking your web sites….and you can even change things in the browser to see what it would look like if….
Virtual PC 2007 Release Candidate….Some said this was problematic…..compared with the beta…..
The new Expression Web looks like a great tool for pure web designers…..Except we don’t get it with MSDN!
http://www.microsoft.com/expression
What was nice is how is automatically creates separate css files etc which I normally have to do by editing the html pages.
It is also better for “cleaning” up a site as it shows you which styles etc are used and not used etc…
I think that SharePoint designer has almost the same features except for a few different wizards….and less standard compliant code for backward compatibility with Front Page.
Will need to play more with SharePoint designer though….
Note: Currently using SharePoint designer instead of front page 2003 and it works fine…..
The new Microsoft Access 2007 is great! And looks very sexy! …..All it needs now is Jenifer Hawkins…….
Anyway this product will be used by many business users for sure which means more work modifying and enhancing Access Databases for years to come.
Adam picked on me because I asked if the Access 2003 issue with multiple choice fields when linking to SharePoint was fixed in 2007!
Wow….now this many to many concept has been simplified and makes database design with Access so much easier and powerful!
Memo fields are now on steroids!..You can do rich text in memo fields….Now I can do my automated spamming ..oops I mean bulk emailing tool with nice text without any html stuffing around….
Memo fields also have versioning etc….
Graphics now can be stored a jpgs and even linked to a file on a hard disk.
Reports have alternative row colouring and an option.
Emails are fixed in Hyperlinks! Before if you used access to edit\update hyperlinked fields it would put an http in front of the mailto:....
Simple click to upgrade the tables to SharePoint or SQL Server.
Apparently some of the access guys went to the SharePoint team and then came back for the 2007 build….The end result is better linking with SharePoint and this powerful new feature.
Also all the ad-hoc querying is made more powerful in that you can sort, filter and even do aggregates without any coding or sql……
There’s a lot more to the new access even the format to cater for the multi-choice etc….But you can hook into older database versions….
Interesting feature is that you can’t reference both ADO and DAO in the references at the same time!...
This might cause some issues as this is needed sometimes when you use dao for linked table checking etc and ado for sql server access…..
There is no replication. No Security ( Every is putting their tables in SQL so that is where to security is) or you can use the older format for security.
The new formats .accdb, .accde, .accdt etc
Note renaming to .accdr can be used to simulate run-time….awesome…..
And lastly the pdf add-in…
Looking forward to using and deploying Access 2007
Tom Bizannes
Databases & Business Intelligence
http://www.smartbiz.com.au
posted by Unknown | 4:07 AM
|
0 Comments
