Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A/R Print Invoice: "Cannot open SQL Server" - Only one user on one batch on one PC

Status
Not open for further replies.

Ho3n3r

Programmer
Sep 26, 2012
23
ZA
Hi

I have one user who has been added to the system since August. She has been printing invoices etc. without problems, including A/R invoices.

Today she's getting the infamous "Cannot open SQL server" on printing a specific batch. She can print any other batch in A/R, but not this single one. I already copied over the Crystal folder from the server to the user's PC, in case it may have had a corrupt file, but to no avail.

The confusing thing for me: Any other user so far who has tried, can indeed print this batch.

And she can log in on another user's PC with her own account, and she can print it. Just not on her PC with her username.

Do you have any advice for me please?

Thanks in advance.
 
Sage ERP Accpac 500 (Version 6.0A)
 
Sage ERP Accpac 6.0A Product Update 1. Nothing after that.
 
OK thanks. But I would rather wait for an answer as to why the same users with the same version as her are able to print, but she isn't - and that she can print all batches bar this specific one.

Obviously something is different, I need to know what it is.

I appreciate it nonetheless.
 
I've been supporting Accpac for 20+ years - over 90% of strange problems are fixed by installing the latest updates. You can ignore that and keep on trying whatever and wishing for a miracle, but installing the latest updates is always my first step.

Sage 300 ERP Certified Consultant
 
That's not up to me anyway, so my hands are tied. I've asked the techie dude on the company's side when they will do updates already and he said "not anytime soon".

Also, there has to be a specific reason that one user gets this on her own PC only. It can't be inexplicable.
 
Your tech is an idiot, that is not acceptable.
I've never seen it happen.
Delete *_P.ISM
Are the program files installed locally (on the C: drive) or do you run workstation setup?
Does it print if another Accpac user logs in on her computer?

Sage 300 ERP Certified Consultant
 
He is - well I do half his work most of the time, but that's another story.

I logged in as ADMIN and it still didn't work. And it is set up via Workstation setup.

I'm trying to get her printing this with all the tools I've got available to me. Thanks for your assistance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top