Could not open the UI in accpac

[SARIESAREER]

I have problem in accpac, that when i want to open charts of accounts, or any other module button to work in it massage appears that "Could not open the UI.
The system may be busy because another application (such as a data conversion application) has locked the company's database. Otherwise, the UI was not opened because an unexpected error has occurred."

and can not access any module to open its childs. and can not work in it.

thanks

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[ettienne]

Versions?
Database?

Do you get the same error when you login as Administrator?

 

[SARIESAREER]

Sage Accpac 5.3B, SQL Server 9.0.1399, I have this problem even for Admin account.

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

The path of your shortcut isn't the same as the Accpac Programs path.

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

So what should i do?????????????????

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

Make them the same.

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

But sometime i can access and sometime the error appears and can not access.

Sometime i can work smoothly all the time but sometime i can not.

And abt which shortcut r u talking abt?, and how to change.

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

The shortcut to Accpac.Exe, make the path just like HKLM\Software\Accpac International Inc\Accpac\Configuration\Programs

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

Oh u mean by that, it is also properly configured.and also for sharedata.

as follow:

HKEY_Local_Machine\software\Accpac International, Inc\Accpac\Configuration\programs C:\program files\Accpac

for share data is:

HKEY_Local_Machine\software\Accpac International, Inc\Accpac\Configuration\programs D:\program files\Accpac


Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

SharedData and Programs do not have to be the same, the SharedData folder can be anywhere.

Programs has to be the same as Accpac.Exe shortcut.

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

Its okay, both have proper configuration, but still here is problem.

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

Consider upgrading your Pervasive database. 9.0 is behind, you need 9.5 for version 5.4, anyway.

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

We are not using pervisave database, inside is Sage Accpac 5.4A, SQL Server 2005.

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

Oh, you said SQL Server 9.0.1399 in an earlier post.

In that case, make sure you're using SQL authentication, not Windows authentication in your ODBC setup.

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

Yes we are using SQL Server 9.0.1399, 2005 version, and we are not using ODBC technology, we r using ADO, i mean editing from regeistry, so no need for ODBC.

And in DB setup we r using SQL authentication, coz we can not use windows authentication.

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

You're not using ODBC? Then no wonder it's not working!

Jay Converse
IT Director
Systemlink, Inc.

 

[SARIESAREER]

Its working befor we have used, our business partner said ODBC use for Oracle and DB2, for SQL Server no need.

Once we install on server, then we r individualy installing for each client, and only change the sharedata path. then the user who have access to sharedata can access ACCPAC.so this is simple way, why need for ODBC

Sareeullah Saree
ERP Support Engineer
Afghan Wireless Communication Company

 

[jayconverse]

Your business partner is completely wrong, ODBC is used for _all_ databases. The SharedData folder has nothing to do with the actual database access, it's for common files like licensing and multi-user semaphors.

Jay Converse
IT Director
Systemlink, Inc.