Adding a Network Printer in VB for Access

[Sweetworks]

I have an old Access Database that my staff uses to Print Labels.

It is run off a Citrix Server as Published Application on a Thin Client.

User that access it can not add printers.

In the past I was able to add a desktop session, add the Printer and then the Printer would be available for the Published Application. It is no longer working.

I want to just create a simple button on the main form that Loads a Printer and set it as default.
That way if the Printer is not in the list, they can go back to the main screen and load the printer.

Windows 2008 Server
Printer Server: \\Print-US
Printer name: Zebra063

 

[kjv1611]

User that access it can not add printers.

If the user cannot add a printer, b/c of permissions, then the user won't be able to do it whether done manually or via VBA.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[Sweetworks]

It is not via permission. It is they do not have their full desktop. It is a published app, running on a thin client and all they see is Access. Their user account has full access to add the printer.

I was hoping their might be a way to create a button that will map a specific printer.

 

[kjv1611]

Ah, gotcha... well, surely there is one.. (I've never tried, but it sounds like a fun little project).

My guess is that it would be best to look to find a way to create a batch file.

Then you could either run the same commands with using Shell from VBA or else build the batch file, and execute the batch file from VBA.

I just did a quick search. Check this out:

http://members.shaw.ca/bsanders/NetPrinterAllUsers.htm

Then do some searching on how to run batch files and/or commands from VBA if you've never done it. There's more than one way that actually works. Do search on vba command line, will most likely get you more than what you need..

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57