Printing in access

in my project i have created a vb front end for querying and minipulating a ms access database.
i can print in it use the preview options etc that can be used in vb but 4 the i have to have the database open on my tastkbar.
i dont however want the user to ever have the database open on the taskbar 4 them to be able to change or view anything in it withought using my vb program


DoCmd.OpenReport ReportName:="finalTable", View:=acViewPreview

is a command im using for example

hope that mkes sence
thx in advance

FiRe5tOrM

the only other option, since you don't want to have the database opened, would be to create the reports in either the VB datareport or a 3rd party report software (Crystal Reports)...then just fill in the areas of the report with the data from the database.

its ok to have the database opened as long as they cant see it open if u know what i mean and that helps?

all my reports are already done in access and i can view them just only by operning up access first

unfortunately, in order to view the access reports you have to create an instance of access and open it...so to do it your way access will have to open and show as far as I know.

ah ok thx is there a way i can open it, bring up just the rteport then close the database then?

In order to view the report, you have to open access...The database is physically opened on the user machine, and can be viewed in the taskbar.

About the only option would be to open access, view/print the report and then immediately close access. Otherwise, you would need to recreate the reports in some other software.

ah ok i think i got it now :)
thx for all your help