Distributing Access Database..Please Help!

[lcdial]

Hey,

I am trying to make a distributable program with an access database. I can read and update the database fine with ADO or DAO, but I have a problem with the report. I have created a report in the database that I want to access from VB. I can print it out and manipulate it by creating an Access object, and it works great, but the user must have Access installed. Is there any way that I can distribute this app to users who do not have a copy of Access? I tried the Office Developer Tools for the Access Runtime, but I haven't gotten any results from that. I do get a runtime error: Automation Error (it translates to RPC Server is not listening) Any advice from anyone? Thanks!


VB6SP3

Go download a program called SnapShot Viewer from Microsoft site. It is compatible with Access 97/2000. The users can view the report object without having the MS Office install in the client PC. You may try to use the Snapshot.ocx and use it in your VB app. Hope this help

[lcdial]

Thanks for the suggestion, and that would work if I were not creating the report from the program. It looks as if I need to just switch the report over to Crystal....<sigh> But thanks anyway!

There is a way to print an Access report from VB. i don't have the code on the top of my head, but when i get back to my main computer I will look it up and post it. Its simple enough. Later.

[lcdial]

Thanks for all your help!! I did finally figure out my problem and it was resulting from using the Access2000 Runtime with an Access97 mdb. Access wants to display to the user a message stating that he/she cannot modify the database b/c of its version. While that message is displayed the VB program continues accessing the application object and it cannot, resulting in a 'RPC Server is not listening' automation error. If anyone has any similar problems, please look to article Q145707 in the KB. Thanks!