How to create script from Access 2000 report

[wiso2010]

I wanted to find out if there was anyway that I could create a script that would tell me which printer in our print servers is not being used by anyone. I currently have a report from MS access 2000 with all the server names and Ip address and printQ. Please let me know how I can do this, I know there's a way but I'm not sure how to begin with this.

[topher23]

Since Access doesn't use scripts, it makes me wonder what you're asking. Could you clarify precisely what you're trying to do?

[wiso2010]

Sorry well I have a access report with all the printers on out network. I wanted to know how I could create a script that I could use to check on every single printer on the network we would like to know which printer is not being used on our network there's a total of 8 print servers.. Any help would great.

[topher23]

I was able to find this MS tutorial on checking printer status. I'm not sure what language the code is written in - not VB. Maybe C#? This may give you a good place to start, though.

http://support.microsoft.com/default.aspx?scid=kb;en-us;160129

And here's another one that uses VB code to call the API for the printer:

http://support.microsoft.com/kb/154078/EN-US/

[NeoPa]

I suggest you look at Windows Scripting Host facilities. There are libraries available for VBA as well as being able to use it with VB Script etc using WScript.Exe or CScript.Exe from a command prompt.