I have a visual basic front end to an Access database. In the access database is a report that i would like to print from a button on the VB form. I have loaded the Access references so i use the command
This opens the report and prints it fine so long as the database is physically open on the desktop however if it is just opened in memory i get an error message Run-time error 2486.
Does anyone know how i can either print the report without opening Access or how i can physically open the database in code before the report prints and then close it again.
Any help would be appreciated