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!

Register Log in
  • Congratulations TouchToneTommy 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

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.
 
Sort by date Sort by votes
Sage ERP Accpac 500 (Version 6.0A)
 
Upvote 0 Downvote
Sage ERP Accpac 6.0A Product Update 1. Nothing after that.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vbdbcoder
  • Locked
  • Question
"Ship All" function does not work for 1 customer
Replies
2
Views
274
vbdbcoder
vbdbcoder
ExtraLean
  • Question
ACCPAC VisionPoint 10 - Need workstation installer or another way to put on new machines
Replies
0
Views
157
ExtraLean
ExtraLean
Ilia Deviatov
  • Locked
  • Question
C# COMAPI Create Cashbook batch with entry type Accounts Payable
Replies
1
Views
186
Ilia Deviatov
Ilia Deviatov
jsh8286
  • Locked
  • Question
Random Slowness One Workstation Sage 300
Replies
0
Views
137
jsh8286
jsh8286
Sage300
  • Locked
  • Question
Customer "price list" is not defaulting in the customer tab in order entry
Replies
1
Views
159
ettienne
ettienne

Part and Inventory Search

Sponsor

Back
Top