sending an acces report to an *.htm format

  • Thread starter Thread starter Alex G
  • Start date Start date
A

Alex G

hi,
i asked the following question in
microsoft.public.vb.general.disscution

"is there a way that the following will work on a pc's without an
Access (just a referance to msAccess objects library)?

..DoCmd.OpenReport "rptMT111", acViewPreview, , , acWindowNormal,
acReadOnly
..DoCmd.OutputTo acOutputReport,"rptMT111",acFormatHTML,ReportPath _
& HtmFileName, True

the above code is due to my client request to issue few reports. he
does not have an access on his system. so we designed the reports on
my Access 2000 (note: we do not have any other reports design tool
beside data report object!!!).
we know we can print or preview the report using an api functions, but
the only way (i know) will make the Access database visible to my user
who will be able to "PLAY" with the objecs (of which we want to
prevent). so i tried the above code which export the report to an
*.htm format and save it in a "reports directory".

the problem is when we tested the application on my user's system
(windows 98/xp and office xp without an Access installed, the report
does not show-up at all and the sub does not save the report (it is
not in side the reports directory).

i read at this forum and in some articles that in order to perform
this, it will not be enought to just make a referance to msAccess
objects library. the user must have Access on his system.


is there a way to perform this with out forcing my user to purchase
Access ?"

in reply to the question, i recieved the following answer:

"no! you are correct...Possibly, assuming that the "run-time version"
of Microsoft Access is still
available. Basically, there is (was?) this thing called Microsoft
Office
Developer which allowed you to distribute a UI-restricted version of
Access
which would only run pre-made databases. I'm not sure how much
Automation
was available (maybe all of it), so even if you can still get ahold of
MSOD
I'm not 100% positive that it'll do what you want.

You might be better off asking in one of the microsoft.public.access.*
groups."

does some one please advise me where can i get that microsoft office
developer, is it free of charge and may be you will also know for 100%
if this will do what i want ?

thanks and best regards
Alex G.
 
i read at this forum and in some articles that in order to perform
this, it will not be enought to just make a referance to msAccess
objects library. the user must have Access on his system.
Click to expand...

Yes, this is true. In order to automate an application, which is what you
are trying to do with VB, the application must be installed.
we know we can print or preview the report using an api functions, but
the only way (i know) will make the Access database visible to my user
who will be able to "PLAY" with the objecs (of which we want to
prevent).
Click to expand...

Well (opinion only) here... depending on your contract/agreement with the
client, if your client has paid you for this application, it is his to "play
with". If he disables one of the reports, bill him for the time required
to visit his office and repair or replace it.
 
Back
Top