AccPacc connectivity problem

Hi there,

I have one windows server and it is working as file server. I have installed ACCPAC (windows Base) .It's realy slow when we loading program at the client side. How i can sole this problem.
bahi1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Freya28Commented:
bothe server and client are in the same office????  n teh same subnet?  also depends on how big the database is.  when the accpac client loads it actually pulls the whole databse

bahi1Author Commented:
All are in the same subnet, same place(Arround 10 meteres), Database is not very big.
Freya28Commented:
even though the DB is not very big ACCPAC runs slow.  it is a flat file database.  how does it open on the server?  better performance?  a lot of times with flat file databse programs, it is best to enable terminal services and rdp into the server and run the program from the server.  how many people need to access ACCPAC?
bahi1Author Commented:
Terminal services are running on the server. Only five clients.Even on the server we have client and it is slow too.
Freya28Commented:
it is the flat file database.  one thing maybe to do is

set client file caching enabled = off and level 2 oplocks enabled =
off and rebooted the server?

Everyone that runs ACCPAC has the same issue.  it is a propietary database and is not tuned for performance.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking

From novice to tech pro — start learning today.