What’s in a #Name?

Sometimes I’ve seen #Name? on MS-Access reports.

When it appears, the report is impossible to export to excel.

Rather than pull your hair out, check to see if the correct ADO reference is loaded in Tools / References. Usually the problem shows up as a missing reference. Fix the reference and the problem goes away.

The REAL challenge is when you’re deploying and MDE or ADE, because the end user can’t change tools / references.

In this case, you should make sure that the DLL MSADO15.DLL is registered. On my machine it lives in “C:\program Files\common Files\System\ado”.

The command to register this file manually is:
regsvr32 “C:\program Files\common Files\System\ado\msado15.dll”

Republish info from a web site

It’s really easy in .NET to output your own censored / transformed version of another web page.

Here’s a code snippet which reads the contents of one web site, does some changes it, and re-publishes it on your own web site.

Make sure strURL has the “http://” at the front of it, and be sure to take acount of the fact that any relative references in the source web will still be relative in the target web.

Dim objRequest As WebRequest = System.Net.HttpWebRequest.Create(strURL)

Dim objResponse As WebResponse = objRequest.GetResponse()

Dim sr As StreamReader = New StreamReader(objResponse.GetResponseStream())

Response.Write(Page, SomeTransformationOf(sr.ReadToEnd()))