Converting Report to Data Access Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day everyone,

I have a report in Access XP that I am trying to save as a Data Access Page.
When I save it, I give it a new name (with no spaces in the file name) and
the Save As type as HTML but then I get:

"Microsoft Access is unable to create the data access page
The file you attempted to load was not recognized as HTML.
You may have selected the wrong file, or tried to open a database file off a
web server."

I then go to the network share where I saved the file to and it creates it
as just a normal HTML page (it doesn't show it with the DAP icon) and when
you open it in Internet Explorer you just get the following error:

"Microsoft JScript runtime error 'null' is null or not an object line = 126,
col = 7 (line is offset from the start of the script block). Error returned
from property or method call."

There are less than 20 lines of code in the code behind file for the report
so I am not sure where to look next. Does anyone have any ideas as to what
might be causing this?

Thanks for your time.

Lance
 
Well, I never received any advice on this so I assumed that it was a fairly
rare occurance. :)

Anyways, I managed to resolve it by referencing this MSDN article (which I
didn't find the first couple of times I looked).

ACC2002: Error When You Save a Form or a Report as a Data Access Page
http://support.microsoft.com/default.aspx?scid=kb;en-us;293357

Essentially it came down to the fact that I had combo boxes that had the
RowSourceType property (not the RowSource property as indicated in the
article) set to 'Table/Query' and the RowSource set to a valid SQL string
(SELECT * FROM blah, blah, blah).

All I did was delete 'Table/Query' from the RowSourceType property and saved
it again as a DAP. No errors.

Hope that helps someone else if they get it.

Lance
 
Back
Top