Can I export Access report as HTML in VB without opening Access

G

Guest

I wrote a VB program to take attendance for the school Library. It scans a
syudents ID, looks up the ID in a database table to get student name etc.
Writes this information to a different table. After all ID's are scanned for
that period I have a button to post the list to our web site so Study hall
monitors can check attendance. I have a report in access to sort the second
database by last name and display the list. I can get this report to export
as HTML however I get promted to open the database with a security warning
when it does. Is there a way to run this report without opening access? Or
is there a way to read the second database into VB to generate an HTML page
that I could save. At the present I am using the

..doCmd.outputto acreport, reportname, acFormatHTML, filename, false, ""

command after opening the database.

Thanks in advance.
Scott
 
G

Guest

Sorry this is here twice! My machine said there was a problem both times I
posted and said neither message had been posted. Sorry again to repost same
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top