O / E Transactions- Jif Entry - Accpac 5.1a Workstation errors

[Electro121]

Hi All,

We have one of our clients that has Accpac 5.1a Workstation client and is receiving an error when trying to work within the Order Entry section.

The client goes into the JIF Entry screen and enters in a valid Order / Job # and pulls up the details. When they go to Print / Post the job an error comes up as follows:

Run-time error '3704'
Operation is not allowed when the object is closed.


Any help on fixing this would be greatly appreciated.

Thanks!

 

[Jay Converse]

What is "JIF Entry"?

 

[Electro121]

It's one of the modules / icons under the O/E Transactions screen.

 

[Jay Converse]

I've done Accpac for over 17 years and never heard of it. Do you know who wrote it? Is it a macro or executable?

 

[Electro121]

Ahh! Good catch Tuba once again!!!

It's a macro so there must be a problem with the Macro itself...Hmm....how are you at your VB skills?

I'm totally clueless when it comes to Accpac unfortunately as I inherited the support of this beast. i might be able to work with the macro though with some help...

 

[Jay Converse]

I've also been programming Accpac macros for 17 years, so I'm pretty good at them.

All you can do is Macro/Edit, hope there isn't a password, and look at the line with the error.

 

[Electro121]

Ok, sounds good...

I've got a guy here in house that knows some VB so he is also working on it. Luckily the macro was not password protected so that's a good thing.

Will keep you posted - and thanks again!

 

[Electro121]

Tuba - Thanks again for pointing me in the right direction (re Macro). We had a look yesterday and determined that it was trying to make a connection to the database and failing.

It was failing because it didn't know how to get to the database. We had to setup an ODBC User DSN. Once we did that, everything worked fine on this users workstation.

That being said, I'm a little puzzled because I did the Pervasive SQL client install and the Accpac Workstation 5.1a install on my workstation and setup the same User DSN. Unfortunately, mine still does not work with the same user ID...???

My error comes back with a window, title bar says Microsoft Forms, and the error in it says "Could not load an object because it is not available on this machine".

As well, we tried it on the server itself (logged directly on at the console)with the same user. If I am logged in as the user and run this macro it appears not even to execute? However, if I log into the Windows server as the administrator, and then into Accpac WS client as the user and run the macro, it works just fine.

WEIRD!

Would like to get this fixed if possible and if you have any thoughts on this would be greatly appreciated!

 

[Jay Converse]

Not weird at all. You have some restrictive AD policies that are preventing your normal account from seeing the System DSN, that's why adding a User DSN fixes it.

For the "could not load an object", edit the macro, then select Tools/References, and see if something is marked "MISSING".

 

[Electro121]

Tuba - You Da Man!

I did what you said for the "could not load object" and found what was missing, turns out an .ocx file was missing on my local machine for some reason. Copied it to the required location and registered it and now my machine works.

Still a problem with the other one though on the server directly.

The Accpac server is a standalone server and using local users, not AD (although it is connected to the AD - don't ask...old config...working to upgrade it moving forward).

I thought maybe a permissions issue so put the using in local administrators but nothing....

Thoughts?

 

[Jay Converse]

My last idea is getting a copy of the REGACC utility that comes with Accpac 5.3 and higher, and run it on that server while logged in as an adminsitrator.

 

[ettienne]

If you do not have the REGACC utility you can open the screen(s) used in the macro on the server and that will register the OCX's.

 

[Electro121]

Well, thanks for the help gents...

I granted the user administrator rights (windows admin rights that is) on the server. Didn't have the REGACC utility so manually used regsvr32.exe to register all of the DLL's and .OCX file associated with this macro while logged in with this user (now an admin).

Unfortunately still no luck. When I try to run the macro, nothing happens, nothing pops up at all.

At least I have a workaround and the user can use it from his local workstation....just not on the server.