How to compile ASP.NET site into one DLL

Never did it before, I thought it would be quite easy, with one click, but appears that there is no such functionality in Visual Studio (unless I missed it?). Fortunately, Microsoft made Visual Studio Web Deployment Projects, which make this part of life easier! Here the steps:

1. Download and install Visual Studio Web Deployment Projects:

VS2010: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=89F2C4F5-5D3A-49B6-BCAD-F776C6EDFA63

VS2008: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=0AA30AE8-C73B-4BDD-BB1B-FE697256C459

2. Open Visual Studio, open your web site, as you normally do

3. Run menu Build -"Add Web Deployment Project"

4. Put the name you like, set location to desired folder

5. Right-click on just created project, Property pages, in output assemblies make sure that "Merge all outputs to a single assembly" selected

6. While deployment project selected in Solution explorer - go to menu Build and run Build <deployment project name>

7. Wait some time while it compiles, then check content of deployment project folder

Creating ADE in Access 2010

This tip I got from Brent Spaulding, Access MVP.
With the default file format option set to "Access 2007" or "Access 2002 - 2003", you can create an ADP (it will be in the respective file format), then subsequently create a corresponding ADE. But if the default file format option is set to "Access 2000", you can create an ADP (it will be in A2000 ADP format), but a corresponding ADE can not be created.

How to export table’s rich text to Word

In Access 2007 and 2010 you can set Memo field property Text format to Rich Text and start entering formatted text there.

But if you export that table to Word RTF file – you lost all formatting. In order to keep formatting – make an export to HTML Document, and then you can open it in Word, and perhaps save as RTF.