Changing Printer with VBA (1 Viewer)

[Ed]

I m trying to make a form on which theres a combo box with the list of the printers.

WHY in excel the application.activeprinter
works and not in ACCESS.

I did found a way to show the printer in the
combo box and changes...
but it puts the database in exclusive use
so every time i use it, it prenvents the other user on the network to use it.

any help would be appriciated